Re: checkpoints taking much longer than expected - Mailing list pgsql-general

From Stephen Frost
Subject Re: checkpoints taking much longer than expected
Date
Msg-id 20190616210925.GW2480@tamriel.snowman.net
Whole thread Raw
In response to Re: checkpoints taking much longer than expected  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: checkpoints taking much longer than expected
List 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

Attachment

pgsql-general by date:

Previous
From: Tiemen Ruiten
Date:
Subject: Re: checkpoints taking much longer than expected
Next
From: Stephen Frost
Date:
Subject: Re: checkpoints taking much longer than expected