Re: High COMMIT times

Поиск
Список
Период
Сортировка
От José Arthur Benetasso Villanova
Тема Re: High COMMIT times
Дата
Msg-id CA+soXCPwygP4ezA+-D6Nfc2WA1KWhAPYzcVUk_hNuPapK3nSLA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: High COMMIT times  (Don Seiler <don@seiler.us>)
Ответы Re: High COMMIT times  (Don Seiler <don@seiler.us>)
Список pgsql-performance
Дерево обсуждения
On Thu, Jan 7, 2021 at 3:03 PM Don Seiler <don@seiler.us> wrote:
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

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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Michael Lewis
Дата:
Сообщение: Re: Autovacuum not functioning for large tables but it is working for few other small tables.
Следующее
От: Don Seiler
Дата:
Сообщение: Re: High COMMIT times