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 [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
