X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4DC4ED1B23C for ; Wed, 14 Jul 2004 07:13:28 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 52017-06 for ; Wed, 14 Jul 2004 10:13:30 +0000 (GMT) Received: from frodo.hserus.net (frodo.hserus.net [204.74.68.40]) by svr1.postgresql.org (Postfix) with ESMTP id 1B73DD1B1BC for ; Wed, 14 Jul 2004 07:13:23 -0300 (ADT) Received: from gateway.pspl.co.in ([203.199.147.2]:3521 helo=frodo.hserus.net) by frodo.hserus.net with asmtp (Cipher TLSv1:DHE-RSA-AES256-SHA:256) (Exim 4.34 #0) id 1BkglU-0005Vn-KY by authid with plain; Wed, 14 Jul 2004 15:43:29 +0530 Message-ID: <40F50742.1000007@frodo.hserus.net> Date: Wed, 14 Jul 2004 15:43:22 +0530 From: Shridhar Daithankar User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en MIME-Version: 1.0 To: gnari Cc: pgsql-performance@postgresql.org Subject: Re: Insert are going slower ... References: <200407131850.52095.herve@elma.fr> <200407131010.30790.josh@agliodbs.com> <200407140142.11720.footcow@noos.fr> <003901c4698a$2cfb5a50$0100000a@wp2000> In-Reply-To: <003901c4698a$2cfb5a50$0100000a@wp2000> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/81 X-Sequence-Number: 7472 gnari wrote: > is there a recommended procedure to estimate > the best value for effective_cache_size on a > dedicated DB server ? Rule of thumb(On linux): on a typically loaded machine, observe cache memory of the machine and allocate good chunk of it as effective cache. To define good chunck of it, you need to consider how many other things are running on that machine. If it is file server + web server + database server, you have to allocate the resources depending upon requirement. But remember It does not guarantee that it will be a good value. It is just a starting point..:-) You have to tune it further if required. HTH Shridhar