pgsql: Introduce pg_dsm_registry_allocations view.

From: Nathan Bossart <nathan(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Introduce pg_dsm_registry_allocations view.
Date: 2025-07-09 14:18:22
Message-ID: E1uZVcs-005Qjl-0b@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Introduce pg_dsm_registry_allocations view.

This commit adds a new system view that provides information about
entries in the dynamic shared memory (DSM) registry. Specifically,
it returns the name, type, and size of each entry. Note that since
we cannot discover the size of dynamic shared memory areas (DSAs)
and hash tables backed by DSAs (dshashes) without first attaching
to them, the size column is left as NULL for those.

Bumps catversion.

Author: Florents Tselai <florents(dot)tselai(at)gmail(dot)com>
Reviewed-by: Sungwoo Chang <swchangdev(at)gmail(dot)com>
Discussion: https://postgr.es/m/4D445D3E-81C5-4135-95BB-D414204A0AB4%40gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/167ed8082f40ee1f3f4cd18cf02bd6d17df57dab

Modified Files
--------------
doc/src/sgml/system-views.sgml | 74 ++++++++++++++++++++++
src/backend/catalog/system_views.sql | 8 +++
src/backend/storage/ipc/dsm_registry.c | 49 ++++++++++++++
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_proc.dat | 8 +++
.../expected/test_dsm_registry.out | 18 ++++++
.../test_dsm_registry/sql/test_dsm_registry.sql | 7 ++
src/test/regress/expected/privileges.out | 15 ++++-
src/test/regress/expected/rules.out | 4 ++
src/test/regress/sql/privileges.sql | 5 +-
10 files changed, 187 insertions(+), 3 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2025-07-09 15:27:00 pgsql: Minor tweaks for pg_test_timing.
Previous Message Masahiko Sawada 2025-07-09 12:46:40 pgsql: Fix tab-completion for COPY and \copy options.