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