| From: | "Rick Gigger" <rick(at)alpinenetworking(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Doug McNaught" <doug(at)mcnaught(dot)org>, "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, "PgSQL General ML" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: performance problem |
| Date: | 2003-11-20 22:21:55 |
| Message-ID: | 01e401c3afb4$b56cdb10$0700a8c0@trogdor |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
> "Rick Gigger" <rick(at)alpinenetworking(dot)com> writes:
> > I am confused. In this tutorial (by Bruce Momjian)
> > http://candle.pha.pa.us/main/writings/pgsql/hw_performance/node8.html
> > it says: "As a start for tuning, use 25% of RAM for cache size, and 2-4%
for
> > sort size."
>
> That advice is widely considered obsolete --- it was developed in the
> days when typical RAM sizes were a lot less than today. I don't believe
> anyone has shown a good case for setting shared_buffers much higher than
> 10000.
>
> regards, tom lane
Thank you!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | fred | 2003-11-20 23:12:18 | Re: Need your help (frustrating issue) |
| Previous Message | Rick Gigger | 2003-11-20 22:20:53 | Re: performance problem |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-11-20 22:39:50 | Re: ERROR: nodeRead: did not find '}' [x2] |
| Previous Message | Rick Gigger | 2003-11-20 22:20:53 | Re: performance problem |