| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Curt Sampson <cjs(at)cynic(dot)net> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Doug Fields <dfields-pg-general(at)pexicom(dot)com>, "Peter A(dot) Daly" <petedaly(at)ix(dot)netcom(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Shared Memory Sizing |
| Date: | 2002-06-26 17:54:47 |
| Message-ID: | 200206261754.g5QHslW19812@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Curt Sampson wrote:
>
> Just going back through old mail, I notice this. So I'm not the only one
> with this opinion. I've seen, at least twice in the last week or so,
> people make the mistake of devoting about half their memory to postgres
> shared memory buffers (the wost thing you can do!). Would someone care
> to go around and find all the spots that talk about this and update them
> to have more reasonable advice?
I advise in my hardware tuning guide that it be increased until paging
starts, then reduce it, and start around 25%. Is that OK?
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Gamache | 2002-06-26 18:15:33 | a "postgres.log" |
| Previous Message | s | 2002-06-26 17:50:44 | ordering error in query? |