Re: High COMMIT times

Поиск
Список
Период
Сортировка
От Don Seiler
Тема Re: High COMMIT times
Дата
Msg-id CAHJZqBD-4mCuvweCwpOcM7g12-xeyCgGUujkFQUP+9XcXcV7wA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: High COMMIT times  (Craig Jackson <craig.jackson@broadcom.com>)
Ответы Re: High COMMIT times  (José Arthur Benetasso Villanova <jose.arthur@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Craig Jackson
Дата:
Сообщение: Re: High COMMIT times
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: High COMMIT times