I just migrated a couple of database (primary + replica) from Heroku and I’m facing with errors I never met on Heroku (I was also running on Postgres 11).
Some long running queries fail with:
** ERROR 40001 (serialization_failure) canceling statement due to conflict with recovery User query might have needed to see row versions that must be removed.
I guess some replica settings are somewhat different between Heroku replica and yours, but I’m no DB expert. Can you help?