Re: Purpose of wal_init_zero - Mailing list pgsql-hackers

From Robert Pang
Subject Re: Purpose of wal_init_zero
Date
Msg-id CAJhEC05A=77oaL_Zt94JttaQMbBJFx7kiBivN62+N9j-VC9uow@mail.gmail.com
Whole thread Raw
In response to Re: Purpose of wal_init_zero  (Ritu Bhandari <mailritubhandari@gmail.com>)
Responses Re: Purpose of wal_init_zero
List pgsql-hackers
On Wed, Jan 15, 2025 at 12:05 PM Andres Freund <andres@anarazel.de> wrote:
>
> If you have wal_recycle=true, this overhead will only be paid the first time a
> WAL segment is used, of course, not after recycling.

Today, our pg_stat_wal view [1] does not report the no. of WAL
segments recycled. How about if we add a column to report it so users
can track how many WAL segments are recycled vs. created over a period
of time?

[1] https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-PG-STAT-WAL-VIEW



pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: POC: enable logical decoding when wal_level = 'replica' without a server restart
Next
From: Robert Treat
Date:
Subject: Re: Set AUTOCOMMIT to on in script output by pg_dump