Re: Shared memory estimation for postgres - Mailing list pgsql-hackers

From leoaaryan
Subject Re: Shared memory estimation for postgres
Date
Msg-id 1478821210077-5929872.post@n3.nabble.com
Whole thread Raw
In response to Re: Shared memory estimation for postgres  (John Scalia <jayknowsunix@gmail.com>)
Responses Re: Shared memory estimation for postgres  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
Hi Jay,

If you are talking about
http://evol-monkey.blogspot.com/2013/08/setting-sharedbuffers-hard-way.html
and the "pg_buffercache" extensions then yes I have gone through it.

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.

-leoaaryan.



--
View this message in context:
http://postgresql.nabble.com/Shared-memory-estimation-for-postgres-tp5929868p5929872.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.



pgsql-hackers by date:

Previous
From: Corey Huinker
Date:
Subject: Re: Do we need use more meaningful variables to replace 0 in catalog head files?
Next
From: Tom Lane
Date:
Subject: Re: Do we need use more meaningful variables to replace 0 in catalog head files?