Re: shared_buffers revisited - Mailing list pgsql-general

From Tom Lane
Subject Re: shared_buffers revisited
Date
Msg-id 5453.995667806@sss.pgh.pa.us
Whole thread Raw
In response to shared_buffers revisited  ("Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>)
List pgsql-general
"Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu> writes:
> Another minor issue that has come to my attention is that when I define
> shared_buffers=40000
> I assume that it'll need a shm segment of 40000*8192=327680000 bytes
> And so I set /proc/sys/kernel/shmall and shmmax accordingly only to find out that postmaster failes to start because
itrequests a shmsegment of 336404480 bytes. Where is the fallacy in my math? 

Shared buffers are not the only things we keep in shared memory ...

            regards, tom lane

pgsql-general by date:

Previous
From: Nate Carlson
Date:
Subject: Microsoft SQL Server Replication
Next
From: "Tim Barnard"
Date:
Subject: Re: Language C - Console-based FrontEnd