Horton

Introduce pg_dsm_registry_allocations view.

Nathan Bossart <nathan@postgresql.org>

View on postgr.es
Commit: 167ed8082f40ee1f3f4cd18cf02bd6d17df57dab
Author: Nathan Bossart <nathan@postgresql.org>
Date: 2025-07-09T14:17:56Z
Releases: 19 (unreleased) 
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.tselai@gmail.com>
Reviewed-by: Sungwoo Chang <swchangdev@gmail.com>
Discussion: https://postgr.es/m/4D445D3E-81C5-4135-95BB-D414204A0AB4%40gmail.com

Files

PathChange+/−
doc/src/sgml/system-views.sgml modified +74 −0
src/backend/catalog/system_views.sql modified +8 −0
src/backend/storage/ipc/dsm_registry.c modified +49 −0
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_proc.dat modified +8 −0
src/test/modules/test_dsm_registry/expected/test_dsm_registry.out modified +18 −0
src/test/modules/test_dsm_registry/sql/test_dsm_registry.sql modified +7 −0
src/test/regress/expected/privileges.out modified +14 −1
src/test/regress/expected/rules.out modified +4 −0
src/test/regress/sql/privileges.sql modified +4 −1

Discussion