Re: High COMMIT times - Mailing list pgsql-performance

From Don Seiler
Subject Re: High COMMIT times
Date
Msg-id CAHJZqBD-4mCuvweCwpOcM7g12-xeyCgGUujkFQUP+9XcXcV7wA@mail.gmail.com
Whole thread Raw
In response to Re: High COMMIT times  (Craig Jackson <craig.jackson@broadcom.com>)
Responses Re: High COMMIT times
List pgsql-performance
On Thu, Jan 7, 2021 at 11:50 AM Craig Jackson <craig.jackson@broadcom.com> wrote:
We had a similar situation recently and saw high commit times that were caused by having unindexed foreign key columns when deleting data with large tables involved.  You might check to see if any new foreign key constraints have been added recently or if any foreign key indexes may have inadvertently been removed. Indexing the foreign keys resolved our issue. 

Interesting, I'll run a check for any. Thanks!

Don.

--
Don Seiler
www.seiler.us

pgsql-performance by date:

Previous
From: Craig Jackson
Date:
Subject: Re: High COMMIT times
Next
From: Laurenz Albe
Date:
Subject: Re: High COMMIT times