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 7DEB3D1B18E for ; Thu, 15 Jul 2004 03:22:07 -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 11049-04 for ; Thu, 15 Jul 2004 06:22:05 +0000 (GMT) Received: from frodo.hserus.net (frodo.hserus.net [204.74.68.40]) by svr1.postgresql.org (Postfix) with ESMTP id 25AAED1B199 for ; Thu, 15 Jul 2004 03:21:57 -0300 (ADT) Received: from gateway.pspl.co.in ([203.199.147.2]:2532 helo=frodo.hserus.net) by frodo.hserus.net with asmtp (Cipher TLSv1:DHE-RSA-AES256-SHA:256) (Exim 4.34 #0) id 1Bkzd3-000Dgc-95 by authid with plain; Thu, 15 Jul 2004 11:52:01 +0530 Message-ID: <40F62284.3090004@frodo.hserus.net> Date: Thu, 15 Jul 2004 11:51:56 +0530 From: Shridhar Daithankar User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en MIME-Version: 1.0 To: =?ISO-8859-15?Q?Herv=E9_Piedvache?= Cc: pgsql-performance@postgresql.org Subject: Re: Insert are going slower ... References: <200407131850.52095.herve@elma.fr> <200407140142.11720.footcow@noos.fr> <200407140928.29498.josh@agliodbs.com> <200407142332.05161.footcow@noos.fr> In-Reply-To: <200407142332.05161.footcow@noos.fr> Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 8bit 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/95 X-Sequence-Number: 7486 Hervé Piedvache wrote: > Josh, > > Le mercredi 14 Juillet 2004 18:28, Josh Berkus a écrit : > >>>checkpoint_segments = 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 : > "NOTE: Since 7.2, turning fsync off does NOT stop WAL. It does stop > checkpointing." > > So ... still true for 7.4.3 ??? So I'm with fsync = off so the value of > checkpoint_segments have no interest ?? > > Thanks for your help... 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. HTH Shridhar