Re: Purpose of wal_init_zero
От | Andy Fan |
---|---|
Тема | Re: Purpose of wal_init_zero |
Дата | |
Msg-id | 87y0z53rd6.fsf@163.com обсуждение исходный текст |
Ответ на | Re: Purpose of wal_init_zero (Nathan Bossart <nathandbossart@gmail.com>) |
Ответы |
Re: Purpose of wal_init_zero
|
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: