Re: Shared memory estimation for postgres

On Fri, Nov 11, 2016 at 8:40 AM, leoaaryan <leoaaryan(at)gmail(dot)com> wrote:
> The easiest way to find the value for the shared memory computation is to
> change the logging level to DEBUG3 and start postgres DB engine and it will
> give the calculated value in the log file.
>
> I believe postgres as a DB needs to be running for any extension to run (I
> may be wrong here) and I dont want to start the database for this analysis.
>
> Please correct me if I'm wrong in my concepts or if I've not understood
> anything.

Some time ago a patch has been proposed to project to a system view
the shared memory allocations currently happening on an instance:
https://www.postgresql.org/message-id/20140504114417.GM12715@awork2.anarazel.de
This could be plugged into its own extension rather easily. Note
though that DSM segments (dynamic shared memory) do not have names
associated to them which would be helpful if you'd like to track that
as well. But perhaps you don't care much.
--
Michael