| From: | km <km(at)mrna(dot)tn(dot)nic(dot)in> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | postgresql.conf shared buffers |
| Date: | 2006-10-03 14:20:42 |
| Message-ID: | 20061003142042.GA2605@mrna.tn.nic.in |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-10-03 14:27:42 | Re: Cause of ERROR: could not open relation |
| Previous Message | Martijn van Oosterhout | 2006-10-03 13:51:25 | Re: Hi, everyone. can i ask a question for th e server side encoding GB18030 and sort order? |