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

2021-12-07 Thread Bharath Rupireddy
On Tue, Dec 7, 2021 at 12:35 AM SATYANARAYANA NARLAPURAM wrote: > > If the segment size is 16MB it shouldn't take much time but higher segment > values this can be a problem. But again, the current segment has to be filled > 75% to precreate new one. I am not sure how much we gain. Do you have

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

2021-12-07 Thread Bharath Rupireddy
On Tue, Dec 7, 2021 at 12:09 PM Noah Misch wrote: > > On Mon, Dec 06, 2021 at 06:21:40PM +0530, Bharath Rupireddy wrote: > > The function PreallocXlogFiles doesn't get called during > > end-of-recovery checkpoint in CreateCheckPoint, see [1]. The server > > becomes operational after the

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

2021-12-07 Thread Bharath Rupireddy
On Tue, Dec 7, 2021 at 1:02 AM Bossart, Nathan wrote: > > On 12/6/21, 4:54 AM, "Bharath Rupireddy" > 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

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

2021-12-06 Thread Noah Misch
On Mon, Dec 06, 2021 at 06:21:40PM +0530, Bharath Rupireddy 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.

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

2021-12-06 Thread Bossart, Nathan
On 12/6/21, 4:54 AM, "Bharath Rupireddy" 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

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

2021-12-06 Thread SATYANARAYANA NARLAPURAM
If the segment size is 16MB it shouldn't take much time but higher segment values this can be a problem. But again, the current segment has to be filled 75% to precreate new one. I am not sure how much we gain. Do you have some numbers with different segment sizes? On Mon, Dec 6, 2021 at 4:51 AM

Do we need pre-allocate WAL files during end-of-recovery checkpoint?

2021-12-06 Thread Bharath Rupireddy
Hi, 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