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 B1EFBD1B248 for ; Fri, 16 Jul 2004 08:17:06 -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 76782-07 for ; Fri, 16 Jul 2004 11:17:03 +0000 (GMT) Received: from mailer.elma.loc (mail.elma.fr [213.41.14.138]) by svr1.postgresql.org (Postfix) with ESMTP id 28359D1B243 for ; Fri, 16 Jul 2004 08:17:00 -0300 (ADT) Received: from mailer.elma.loc (localhost [127.0.0.1]) by localhost (Postfix) with ESMTP id C0A15EC1D0; Fri, 16 Jul 2004 12:20:14 +0200 (CEST) Received: from zoot.elma.fr (herve.elma.fr [10.0.1.2]) by mailer.elma.loc (Postfix) with ESMTP id 8915AEC0EA; Fri, 16 Jul 2004 12:20:14 +0200 (CEST) From: =?iso-8859-15?q?Herv=E9_Piedvache?= Organization: Elma =?iso-8859-15?q?Ing=E9nierie?= Informatique To: pgsql-performance@postgresql.org, josh@agliodbs.com Subject: Re: Insert are going slower ... Date: Fri, 16 Jul 2004 13:17:02 +0200 User-Agent: KMail/1.6.2 Cc: Shridhar Daithankar , =?iso-8859-15?q?Herv=E9_Piedvache?= References: <200407131850.52095.herve@elma.fr> <40F62284.3090004@frodo.hserus.net> <200407151109.16466.josh@agliodbs.com> In-Reply-To: <200407151109.16466.josh@agliodbs.com> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: 8bit Message-Id: <200407161317.02515.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/107 X-Sequence-Number: 7498 Josh, Le jeudi 15 Juillet 2004 20:09, Josh Berkus a écrit : > > I suggest you check this first. Check the performance tuning guide.. > > > > http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php > > > > That is a starters. As Josh suggested, increase checkpoint segments if > > you > > have > > > disk space. Correspondingly WAL disk space requirements go up as well. > > Well, not if he has fsync=off. But having fsync off is a very bad idea. > You do realize, Herve', that if you lose power on that machine you'll most > likely have to restore from backup? Hum ... it's only for speed aspect ... I was using postgresql with this option since 7.01 ... and for me fsync=on was so slow ... Is it really no time consuming for the system to bring it ON now with v7.4.3 ?? Tell me ... -- Hervé Piedvache Elma Ingénierie Informatique 6 rue du Faubourg Saint-Honoré F-75008 - Paris - France Pho. 33-144949901 Fax. 33-144949902