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 7AB07D1B19C for ; Wed, 14 Jul 2004 18:32:12 -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 36287-09 for ; Wed, 14 Jul 2004 21:32:06 +0000 (GMT) Received: from mx.noos.fr (pm-mx4.mgn.net [195.46.220.210]) by svr1.postgresql.org (Postfix) with ESMTP id 8651ED1B1A5 for ; Wed, 14 Jul 2004 18:32:03 -0300 (ADT) Received: from noos.fr (pm-mnet3.mgn.net [195.46.220.218]) by mx.noos.fr (Postfix) with SMTP id 5FB1826860; Wed, 14 Jul 2004 23:32:05 +0200 (MEST) X-Mailbox-Line: From footcow@noos.fr Wed Jul 14 23:32:05 2004 Received: from e115.dhcp212-198-145.noos.fr (e115.dhcp212-198-145.noos.fr [212.198.145.115]) by pm-mnet3.mgn.net with ESMTP; Wed, 14 Jul 2004 23:32:05 (MEST) From: =?iso-8859-15?q?Herv=E9_Piedvache?= To: pgsql-performance@postgresql.org Subject: Re: Insert are going slower ... Date: Wed, 14 Jul 2004 23:32:05 +0200 User-Agent: KMail/1.6.2 Cc: Josh Berkus , =?iso-8859-15?q?Herv=E9_Piedvache?= References: <200407131850.52095.herve@elma.fr> <200407140142.11720.footcow@noos.fr> <200407140928.29498.josh@agliodbs.com> In-Reply-To: <200407140928.29498.josh@agliodbs.com> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: quoted-printable Message-Id: <200407142332.05161.footcow@noos.fr> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=RCVD_IN_NJABL, RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/86 X-Sequence-Number: 7477 Josh, Le mercredi 14 Juillet 2004 18:28, Josh Berkus a =E9crit : > > > checkpoint_segments =3D 3 > > You should probably increase this if you have the disk space. For massive > insert operations, I've found it useful to have as much as 128 segments > (although this means about 1.5GB disk space) Other point I have also read this :=20 "NOTE: Since 7.2, turning fsync off does NOT stop WAL. It does stop=20 checkpointing." So ... still true for 7.4.3 ??? So I'm with fsync =3D off so the value of= =20 checkpoint_segments have no interest ?? Thanks for your help... --=20 Bill Footcow