Postgres Pro
Downloads
Home   >   mailing lists

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

From Bossart, Nathan
Subject Re: Do we need pre-allocate WAL files during end-of-recovery checkpoint?
Date
Msg-id 2F433CA6-FD9D-4D38-82BF-541FF48CA7A9@amazon.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>)
Responses Re: Do we need pre-allocate WAL files during end-of-recovery checkpoint?
List pgsql-hackers
Tree view 
On 12/6/21, 4:54 AM, "Bharath Rupireddy" <bharath.rupireddyforpostgres@gmail.com> wrote:
> The function PreallocXlogFiles doesn't get called during
> end-of-recovery checkpoint in CreateCheckPoint, see [1]. The server
> becomes operational after the end-of-recovery checkpoint and may need
> WAL files. However, I'm not sure how beneficial it is going to be if
> the WAL is pre-allocated (as PreallocXlogFiles just allocates only 1
> extra WAL file).

There is another thread for adding more effective WAL pre-allocation
[0] that you might be interested in.

Nathan

[0] https://www.postgresql.org/message-id/flat/20201225200953.jjkrytlrzojbndh5%40alap3.anarazel.de

pgsql-hackers by date:

Previous
From: "Bossart, Nathan"
Date:
Subject: Re: Is it correct to update db state in control file as "shutting down" during end-of-recovery checkpoint?
Next
From: Robert Haas
Date:
Subject: Re: Why doesn't pgstat_report_analyze() focus on not-all-visible-page dead tuple counts, specifically?