Get the latest tech news
System View for Inspecting DSM Registry Allocations in PostgreSQL
New System View for PostgreSQL: Inspecting DSM Registry Allocations The dynamic shared memory (DSM) registry (introduced in 8b2bcf3) is a convenient way for PostgreSQL extensions (and core components) to allocate dynamic shared memory and associate it with a string name. In its initial form (PostgreSQL 17), it only supported allocating DSM segments via the GetNamedDSMSegment function.
Personally, I’ve been (ab)using the DSM registry quite a lot because I find it incredibly powerful. With these facilities, you can design really sophisticated interactions, leveraging PostgreSQL’s shared memory to store arbitrary metadata across backends. It’s only natural to want insight into what’s happening under the hood—especially since PostgreSQL has traditionally offered system views precisely for these use cases.
Or read this on Hacker News