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 EC2B4D1B170 for ; Tue, 13 Jul 2004 14:10:33 -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 48689-05 for ; Tue, 13 Jul 2004 17:10:25 +0000 (GMT) Received: from davinci.ethosmedia.com (server226.ethosmedia.com [209.128.84.226]) by svr1.postgresql.org (Postfix) with ESMTP id 54973D1B1B0 for ; Tue, 13 Jul 2004 14:10:24 -0300 (ADT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 5742686; Tue, 13 Jul 2004 10:11:34 -0700 Content-Type: text/plain; charset="iso-8859-15" From: Josh Berkus Organization: Aglio Database Solutions To: =?iso-8859-15?q?Herv=E9=20Piedvache?= , pgsql-performance@postgresql.org Subject: Re: Insert are going slower ... Date: Tue, 13 Jul 2004 10:10:30 -0700 User-Agent: KMail/1.4.3 References: <200407131850.52095.herve@elma.fr> In-Reply-To: <200407131850.52095.herve@elma.fr> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200407131010.30790.josh@agliodbs.com> 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/74 X-Sequence-Number: 7465 Herve, > What can I do to get better results ?? (configuration option, and/or > hardware update ?) > What can I give you to get more important informations to help me ? 1) What PostgreSQL version are you using? 2) What's your VACUUM, ANALYZE, VACUUM FULL, REINDEX schedule? 3) Can you list the non-default settings in your PostgreSQL.conf? Particularly, shared_buffers, sort_mem, checkpoint_segments, estimated_cache, and max_fsm_pages? -- Josh Berkus Aglio Database Solutions San Francisco