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 10AFBD1B266 for ; Wed, 14 Jul 2004 07:04:03 -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 49871-02 for ; Wed, 14 Jul 2004 10:04:04 +0000 (GMT) Received: from quasar.skima.is (quasar.skima.is [212.30.200.205]) by svr1.postgresql.org (Postfix) with ESMTP id 0B20ED1B26C for ; Wed, 14 Jul 2004 07:03:55 -0300 (ADT) Received: from wp2000 ([157.157.176.72] [157.157.176.72]) by quasar.skima.is; Wed, 14 Jul 2004 10:04:02 Z Message-Id: <003901c4698a$2cfb5a50$0100000a@wp2000> From: "gnari" To: References: <200407131850.52095.herve@elma.fr> <200407131010.30790.josh@agliodbs.com> <200407140142.11720.footcow@noos.fr> Subject: Re: Insert are going slower ... Date: Wed, 14 Jul 2004 10:06:05 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/80 X-Sequence-Number: 7471 From: "Hervé Piedvache" Sent: Tuesday, July 13, 2004 11:42 PM > effective_cache_size = 5000000 looks like madness to me. my (modest) understanding of this, is that you are telling postgres to assume a 40Gb disk cache (correct me if I am wrong). btw, how much effect does this setting have on the planner? is there a recommended procedure to estimate the best value for effective_cache_size on a dedicated DB server ? gnari