| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | David Esposito <pgsql-general(at)esposito(dot)newnetco(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Performance tuning on RedHat Enterprise Linux 3 |
| Date: | 2004-12-06 16:31:01 |
| Message-ID: | 20041206163101.GF7455@dcc.uchile.cl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Dec 06, 2004 at 09:08:02AM -0500, David Esposito wrote:
> According to Bruce Momjian's performance tuning guide, he recommends roughly
> half the amount of physical RAM for the shared_buffers ...
Does he? The guide I've seen from him AFAIR states that you should
allocate around 10% of physical RAM to shared_buffers. And this advice
goes against common Postgres folklore. Maybe it's a document that needs
to be updated.
--
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
"There is evil in the world. There are dark, awful things. Occasionally, we get
a glimpse of them. But there are dark corners; horrors almost impossible to
imagine... even in our worst nightmares." (Van Helsing, Dracula A.D. 1972)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mjmayfield | 2004-12-06 16:33:31 | unsubscribe |
| Previous Message | Alvaro Herrera | 2004-12-06 16:18:30 | Re: Index bloat in 7.2 |