Re: High COMMIT times - Mailing list pgsql-performance

From Don Seiler
Subject Re: High COMMIT times
Date
Msg-id CAHJZqBDe3cExU1m90HgADQv9kRHjLh7BvJVnyzzLjZHd0+tauw@mail.gmail.com
Whole thread Raw
In response to Re: High COMMIT times  (José Arthur Benetasso Villanova <jose.arthur@gmail.com>)
List pgsql-performance
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.

Don.

--
Don Seiler
www.seiler.us

pgsql-performance by date:

Previous
From: José Arthur Benetasso Villanova
Date:
Subject: Re: High COMMIT times
Next
From: Craig Jackson
Date:
Subject: Re: High COMMIT times