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
thekernel to increase this value ? or is there any workaround ?
tia,
regards,
KM