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).
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..


---------------------------(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

Reply via email to