Re: checkpoints taking much longer than expected

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: checkpoints taking much longer than expected
Дата
Msg-id 20190616210925.GW2480@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: checkpoints taking much longer than expected  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: checkpoints taking much longer than expected  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-general
Greetings,

* Alvaro Herrera (alvherre@2ndquadrant.com) wrote:
> On 2019-Jun-16, Stephen Frost wrote:
> > Not likely to help with what you're experiencing anyway though...
>
> My gut feeling is that you're wrong, since (as I understand) the
> symptoms are the same.

The issue in the linked-to thread was that of a synch replica getting
stuck doing a random read of a WAL page in order to append to it, since
we were reusing WAL.

The issue being discussed here is writing out to the heap files during a
checkpoint...

Thanks,

Stephen

Вложения

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

Предыдущее
От: Tiemen Ruiten
Дата:
Сообщение: Re: checkpoints taking much longer than expected
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: checkpoints taking much longer than expected