On Fri, Jan 8, 2021 at 11:52 AM José Arthur Benetasso Villanova <jose.arthur@gmail.com> wrote:
Do you have standby databases and synchronous_commit = 'remote_apply'?
We have standby databases, but synchronous_commit is "on".
I found a pair of unindexed foreign key child tables but they never run deletes on those and they are very small. I did mention it to the app team as a best practice in the meantime but I don't think it would play a part in our current issue.