Re: pg_shmem_allocations view

On Fri, May 6, 2016 at 8:01 AM, Andres Freund <andres(at)anarazel(dot)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