Re: [PERFORM] Optimize

[Shridhar Daithankar]

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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match