Re: wal_init_zero / wal_recycle

2024-04-25 Thread Alvaro Herrera
On 2024-Apr-24, Peter Eisentraut wrote: > On 24.04.24 10:08, Nicolas Seinlet wrote: > > It was not crystal clear to me that when wal_recycle is also ON , the > > recycled files are not filled with zeroes, because they are not > > considered as new. Could we add a sentence stating this? > > It cu

Re: wal_init_zero / wal_recycle

2024-04-24 Thread Nicolas Seinlet
On Wednesday, April 24th, 2024 at 10:57, Peter Eisentraut wrote: > It currently says: > > wal_init_zero: "... causes new WAL files to be filled with zeroes ..." > > wal_recycle: "... avoiding the need to create new ones ..." > > I'm not sure where exactly to make that more clear. You

Re: wal_init_zero / wal_recycle

2024-04-24 Thread Peter Eisentraut
On 24.04.24 10:08, Nicolas Seinlet wrote: while searching the doc to solve an issue, I found the interdependency between those 2 parameters was not obvious. Here: https://www.postgresql.org/docs/14/runtime-config-wal.html#GUC-WAL-INIT-ZERO

wal_init_zero / wal_recycle

2024-04-24 Thread Nicolas Seinlet
Hello, while searching the doc to solve an issue, I found the interdependency between those 2 parameters was not obvious. Here: https://www.postgresql.org/docs/14/runtime-config-wal.html#GUC-WAL-INIT-ZERO the wal_init_zero set to ON cause new WAL files to beĀ filled with zeroes. It was not crys