X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2EE43D1B48D for ; Wed, 26 Nov 2003 06:07:11 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 92857-09 for ; Wed, 26 Nov 2003 02:06:40 -0400 (AST) Received: from smtp.pspl.co.in (www.pspl.co.in [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id A9920D1B434 for ; Wed, 26 Nov 2003 02:06:37 -0400 (AST) Received: (from root@localhost) by smtp.pspl.co.in (8.12.9/8.12.9) id hAQ66gCZ030653 for ; Wed, 26 Nov 2003 11:36:42 +0530 Received: from persistent.co.in (daithan.intranet.pspl.co.in [192.168.7.161]) (authenticated bits=0) by persistent.co.in (8.12.9/8.12.9) with ESMTP id hAQ66eLp030627; Wed, 26 Nov 2003 11:36:40 +0530 Message-ID: <3FC442EA.7060300@persistent.co.in> Date: Wed, 26 Nov 2003 11:36:34 +0530 From: Shridhar Daithankar Organization: Persistent Systems Pvt. Ltd. User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5) Gecko/20031013 Thunderbird/0.3 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Torsten Schulz Cc: pgsql-performance@postgresql.org Subject: Re: Optimize References: <3FC3D296.9040404@be-a-part.de> In-Reply-To: <3FC3D296.9040404@be-a-part.de> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/264 X-Sequence-Number: 4824 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