Re: Remove wal_[sync|write][_time] from pg_stat_wal and track_wal_io_timing
Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
From: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
To: Michael Paquier <michael@paquier.xyz>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2025-02-20T08:11:12Z
Lists: pgsql-hackers
Hi, On Thu, Feb 20, 2025 at 02:37:18PM +0900, Michael Paquier wrote: > On Wed, Feb 19, 2025 at 09:24:41AM +0000, Bertrand Drouvot wrote: > > That's right but that would mean almost duplicating the pg_stat_wal related > > stuff (because it can't be removed from the doc until the fields are gone). I > > think it's simpler to do it as proposed initially (the end result is the same). > > After sleeping on it, I still saw no reason to not apply the changes > from 0002 in wal.sgml to describe that the stats for the writes/fsyncs > are in pg_stat_io rather than pg_stat_wal for the "WAL configuration" > section, so done that. I see, I did not get that you wanted to get rid of the pg_stat_wal part before removing the fields. Makes sense that way to "just" replace the pg_stat_wal by pg_stat_io first in the doc as you've done in 4538bd3f1dd. > and I've moved that as a paragraph not under the tuning part, to make > it a more general statement with its link to "WAL configuration", > which is a very popular link for pg_stat_io. Makes more sense, agree. > Attached is the rest, as of v3-0002. LGTM. Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com
Commits
-
Re-add GUC track_wal_io_timing
- 6c349d83b607 18.0 landed
-
Remove read/sync fields from pg_stat_wal and GUC track_wal_io_timing
- 2421e9a51d20 18.0 landed
-
doc: Fix typo in section "WAL configuration"
- f11674f8dfe8 18.0 landed
-
doc: Add details about object "wal" in pg_stat_io
- 4538bd3f1dde 18.0 landed
-
doc: Recommend pg_stat_io rather than pg_stat_wal in WAL configuration
- 2f70871c2bc1 18.0 landed