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 EA250D1B19C for ; Wed, 14 Jul 2004 11:08:24 -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 45905-10 for ; Wed, 14 Jul 2004 14:08:28 +0000 (GMT) Received: from mailer.elma.loc (mail.elma.fr [213.41.14.138]) by svr1.postgresql.org (Postfix) with ESMTP id E3F9AD1B19B for ; Wed, 14 Jul 2004 11:08:18 -0300 (ADT) Received: from mailer.elma.loc (localhost [127.0.0.1]) by localhost (Postfix) with ESMTP id CCD4EEC11F; Wed, 14 Jul 2004 15:11:43 +0200 (CEST) Received: from zoot.elma.fr (herve.elma.fr [10.0.1.2]) by mailer.elma.loc (Postfix) with ESMTP id 9EE87EC00F; Wed, 14 Jul 2004 15:11:43 +0200 (CEST) From: =?iso-8859-15?q?Herv=E9_Piedvache?= Organization: Elma =?iso-8859-15?q?Ing=E9nierie?= Informatique To: pgsql-performance@postgresql.org Subject: Re: Insert are going slower ... Date: Wed, 14 Jul 2004 16:08:27 +0200 User-Agent: KMail/1.6.2 Cc: Shridhar Daithankar , gnari References: <200407131850.52095.herve@elma.fr> <003901c4698a$2cfb5a50$0100000a@wp2000> <40F50742.1000007@frodo.hserus.net> In-Reply-To: <40F50742.1000007@frodo.hserus.net> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: 8bit Message-Id: <200407141608.27116.herve@elma.fr> 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/82 X-Sequence-Number: 7473 Le mercredi 14 Juillet 2004 12:13, Shridhar Daithankar a écrit : > 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. In my case it's a PostgreSQL dedicated server ... effective_cache_size = 5000000 For me I give to the planner the information that the kernel is able to cache 5000000 disk page in RAM >free total used free shared buffers cached Mem: 7959120 7712164 246956 0 17372 7165704 -/+ buffers/cache: 529088 7430032 Swap: 2097136 9880 2087256 What should I put ? Regards, -- Hervé Piedvache Elma Ingénierie Informatique 6 rue du Faubourg Saint-Honoré F-75008 - Paris - France Pho. 33-144949901 Fax. 33-144949902