Re: High COMMIT times

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Jan 8, 2021 at 11:52 AM José Arthur Benetasso Villanova <jose.arthur@xxxxxxxxx> 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.

Don.

--
Don Seiler
www.seiler.us

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux