On Fri, Nov 11, 2016 at 8:40 AM, leoaaryan <leoaar...@gmail.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.gm12...@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 -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers