pgsql: Add bt_multi_page_stats() function to contrib/pageinspect.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add bt_multi_page_stats() function to contrib/pageinspect.
Date: 2023-01-02 18:02:41
Message-ID: E1pCP8z-001hut-Ka@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add bt_multi_page_stats() function to contrib/pageinspect.

This is like the existing bt_page_stats() function, but it can
report on a range of pages rather than just one at a time.

I don't have a huge amount of faith in the portability of the
new test cases, but they do pass in a 32-bit FreeBSD VM here.
Further adjustment may be needed depending on buildfarm results.

Hamid Akhtar, reviewed by Naeem Akhter, Bertrand Drouvot,
Bharath Rupireddy, and myself

Discussion: https://postgr.es/m/CANugjht-=oGMRmNJKMqnBC69y7vr+wHDmm0ZK6-1pJsxoBKBbA@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/1fd3dd2048991a164c287dc29fdb78b1f7e6e14e

Modified Files
--------------
contrib/pageinspect/Makefile | 2 +-
contrib/pageinspect/btreefuncs.c | 298 ++++++++++++++++++------
contrib/pageinspect/expected/btree.out | 121 +++++++++-
contrib/pageinspect/meson.build | 1 +
contrib/pageinspect/pageinspect--1.11--1.12.sql | 23 ++
contrib/pageinspect/pageinspect.control | 2 +-
contrib/pageinspect/sql/btree.sql | 11 +
doc/src/sgml/pageinspect.sgml | 50 +++-
8 files changed, 428 insertions(+), 80 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Geoghegan 2023-01-02 18:17:07 pgsql: Avoid special XID snapshotConflictHorizon values.
Previous Message Peter Eisentraut 2023-01-02 08:44:50 pgsql: Push lpp variable closer to usage in heapgetpage()