pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Peter Geoghegan <pg@bowt.ie>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Show record information in pg_get_wal_block_info.
Date: Thu, 30 Mar 2023 19:27:14 +0000
Message-ID: <E1phxvU-000WOg-Sk@gemulon.postgresql.org> (raw)

Show record information in pg_get_wal_block_info.

Expand the output parameters in pg_walinspect's pg_get_wal_block_info
function to return additional information that was previously only
available from pg_walinspect's pg_get_wal_records_info function.  Some
of the details are attributed to individual block references, rather
than aggregated into whole-record values, since the function returns one
row per block reference per WAL record (unlike pg_get_wal_records_info,
which always returns one row per WAL record).

This structure is much easier to work with when writing queries that
track how individual blocks changed over time, or when attributing costs
to individual blocks (not WAL records) is useful.

This is the second time that pg_get_wal_block_info has been enhanced in
recent weeks.  Commit 9ecb134a expanded on the original version of the
function added in commit c31cf1c0 (where it first appeared under the
name pg_get_wal_fpi_info).  There still hasn't been a stable release
since commit c31cf1c0, so no bump in the pg_walinspect extension
version.

Author: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Author: Peter Geoghegan <pg@bowt.ie>
Reviewed-By: Peter Geoghegan <pg@bowt.ie>
Reviewed-By: Kyotaro HORIGUCHI <horikyota.ntt@gmail.com>
Discussion: https://postgr.es/m/CALj2ACVRK5=Z+2ZVsjgTTSkfEnQzCuwny7iigpG7g1btk4Ws2A@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/122376f028a0e31b91d6c6bad2a9a6e994708547

Modified Files
--------------
contrib/pg_walinspect/expected/pg_walinspect.out  |   4 +-
contrib/pg_walinspect/pg_walinspect--1.0--1.1.sql |  23 ++-
contrib/pg_walinspect/pg_walinspect.c             | 197 +++++++++++++--------
contrib/pg_walinspect/sql/pg_walinspect.sql       |   4 +-
doc/src/sgml/pgwalinspect.sgml                    | 205 ++++++++++++++--------
5 files changed, 273 insertions(+), 160 deletions(-)



Message-ID: <E1phxvU-000WOg-Sk@gemulon.postgresql.org>
Permalink:  ../E1phxvU-000WOg-Sk@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1phxvU-000WOg-Sk@gemulon.postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-committers@postgresql.org
  Cc: pg@bowt.ie, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: Show record information in pg_get_wal_block_info.
  In-Reply-To: <E1phxvU-000WOg-Sk@gemulon.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox