Re: Optimize

Torsten Schulz wrote:

> Chester Kustarz wrote:

>> On Mon, 24 Nov 2003, Torsten Schulz wrote:
>>> shared_buffers = 5000        # 2*max_connections, min 16
>> that looks pretty small. that would only be 40MBytes (8k/page *
>> 5000pages).
>> http://www.varlena.com/GeneralBits/Tidbits/perf.html
> Ok, thats it. I've set it to 51200, now it seems to be very fast.

Whoa..That is too much. You acn get still better performance at something low
like 10,000 or even 5000.

Bumping up shared buffers stops being useful after a point and later it actually
degrades the performance..

  Shridhar