Hi, 

> On Fri, Jan 17, 2025 at 04:29:14PM -0500, Andres Freund wrote:
>> I think what we instead ought to do is to more aggressively initialize WAL
>> files ahead of time, so it doesn't happen while holding crucial locks.  We
>> know the recent rate of WAL generation, and we could easily track up to which
>> LSN we have recycled WAL segments. Armed with that information walwriter (or
>> something else) should try to ensure that there's always a fair amount of
>> pre-allocated WAL.
>
> I put some patches together for this a few years ago [0], but ended up
> abandoning them due to lack of interest.  I'm happy to revisit that effort
> if folks do become interested.

Great to know this, I went through that thread and found the main
considerations are pretty similar with what I am thinking when working
out the Poc. I will go to [0] for further dicussion on this topic.

> [0] https://postgr.es/m/20220408203003.GA1630183%40nathanxps13
-- 
Best Regards
Andy Fan



Reply via email to