Re: postgresql.conf shared buffers

Please take a look at
http://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html first.

In a nutshell, set shared_buffers to between 10% and 25% of your memory
if it's a server. And increase estimated_cache_size to something close
to how much memory you have.

On Tue, Oct 03, 2006 at 07:50:42PM +0530, km wrote:
> Hi all,
>
> - What does the shared_buffers setting do ?
> - Does it mean that that the postgres cannot access most of the physical RAM but limited to the memory setting (shared_buffers) specified ?
> - How do i relate and set max_connections and shared_buffers?
> - Is there a thumb rule to determine shared_buffers from max connections ?
> - I see , by default max_connections set to 100 and shared_buffers to 1000 - does 1000 mean 1000 bytes or KB ?
> - Also postgres will not start if the shared_buffers value exceeds the kernel setting of SHMMAX. do i need to recompile the kernel to increase this value ? or is there any workaround ?
>
> tia,
> regards,
> KM
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)