Re: Do we need pre-allocate WAL files during end-of-recovery checkpoint? - Mailing list pgsql-hackers

From Bharath Rupireddy
Subject Re: Do we need pre-allocate WAL files during end-of-recovery checkpoint?
Date
Msg-id CALj2ACWWGUnq1oYcTVF7NNUCFEn7Osnnza1dz789U6E8bmoqYA@mail.gmail.com
Whole thread Raw
In response to Re: Do we need pre-allocate WAL files during end-of-recovery checkpoint?  (SATYANARAYANA NARLAPURAM <satyanarlapuram@gmail.com>)
List pgsql-hackers
On Tue, Dec 7, 2021 at 12:35 AM SATYANARAYANA NARLAPURAM
<satyanarlapuram@gmail.com> wrote:
>
> If the segment size is 16MB it shouldn't take much time but higher segment values this can be a problem. But again,
thecurrent segment has to be filled 75% to precreate new one. I am not sure how much we gain. Do you have some numbers
withdifferent segment sizes? 

I don't have the numbers. However I agree that the pre-allocation can
make end-of-recovery checkpoint times more. At times, the
end-of-recovery checkpoint itself will take a good amount of time and
adding to it the pre-allocation of WAL time doesn't make sense.

Regards,
Bharath Rupireddy.



pgsql-hackers by date:

Previous
From: Dilip Kumar
Date:
Subject: Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints
Next
From: Bharath Rupireddy
Date:
Subject: Re: Pre-allocating WAL files