Re: performance problem - Mailing list pgsql-general

From Rick Gigger
Subject Re: performance problem
Date
Msg-id 01e401c3afb4$b56cdb10$0700a8c0@trogdor
Whole thread Raw
In response to Re: performance problem  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
> "Rick Gigger" <rick@alpinenetworking.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!


pgsql-general by date:

Previous
From: "Rick Gigger"
Date:
Subject: Re: performance problem
Next
From: Tom Lane
Date:
Subject: Re: ERROR: nodeRead: did not find '}' [x2]