Re: pg_shmem_allocations view

On Fri, May 6, 2016 at 8:01 AM, Andres Freund <andres@anarazel.de> wrote:
> Here's a rebased version.  I remember why I didn't call the column
> "offset" (as Michael complained about upthread), it's a keyword...

Oh, an old patch resurrected from the dead... Reading again the patch

+    * Increase number of initilized slots if we didn't reuse a previously
+    * used one.
s/initilized/initialized

+       Number of backends attached to this segment (1 signals a moribund
+       entry, 2 signals one user, ...).
moribund? Or target for removal.

REVOKE ALL .. FROM PUBLIC;
REVOKE EXECUTE .. ON FUNCTION FROM PUBLIC;
Revoking he execution of those views and their underlying functions
would be a good thing I think, this can give hints on the system
activity, particularly for DSM segments.
-- 
Michael