Pavan, Thanks. I'll have a look at the source code. M. ________________________________________ From: Pavan Deolasee [pavan.deolasee@xxxxxxxxx] Sent: Wednesday, February 06, 2013 10:41 PM To: Mel Llaguno Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: PostgreSQL's share_buffer calculation using shmget() versus kernel.shmmax On Thu, Feb 7, 2013 at 11:01 AM, Mel Llaguno <mllaguno@xxxxxxxxxxxx> wrote: > Having to guess this value is far from ideal; what I'd like is the formula used by postgresql that generates the shmget() value displayed in the pgctl.log. > There is no easy way or at least none that I'm aware of, to get the exact value of shared memory needed for Postgres. If you have access to the source code, you can look at CreateSharedMemoryAndSemaphores() function in src/backend/storage/ipc/ipci.c to see what all goes in determining the size for shmget() Thanks, Pavan -- Pavan Deolasee http://www.linkedin.com/in/pavandeolasee -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
