| From: | Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in> |
|---|---|
| To: | Torsten Schulz <comic(at)be-a-part(dot)de> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Optimize |
| Date: | 2003-11-26 06:06:34 |
| Message-ID: | 3FC442EA.7060300@persistent.co.in |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roger Ging | 2003-11-26 16:38:27 | expression (functional) index use in joins |
| Previous Message | Andrew Sullivan | 2003-11-26 04:27:46 | Re: [PERFORM] More detail on settings for pgavd? |