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
<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 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 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.
