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
