Re: performance problem

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Rick Gigger <rick(at)alpinenetworking(dot)com>, 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 23:50:34
Message-ID: 200311202350.hAKNoYr23484@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Tom Lane wrote:
> "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.

Yes, I will update that page shortly.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Leif K-Brooks 2003-11-21 02:45:02 Default login info?
Previous Message fred 2003-11-20 23:12:18 Re: Need your help (frustrating issue)

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2003-11-21 00:28:07 Re: PostgreSQL v7.4 Released
Previous Message Tom Lane 2003-11-20 23:36:27 Re: PostgreSQL v7.4 Released