Re: High COMMIT times

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

 



On Thu, Jan 7, 2021 at 3:03 PM Don Seiler <don@xxxxxxxxx> wrote:
On Thu, Jan 7, 2021 at 11:50 AM Craig Jackson <craig.jackson@xxxxxxxxxxxx> 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

Do you have standby databases and synchronous_commit = 'remote_apply'?
--
José Arthur Benetasso Villanova

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

  Powered by Linux