Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 0D5CF1337B9E for ; Fri, 4 Feb 2011 17:22:45 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 79902-09 for ; Fri, 4 Feb 2011 21:22:37 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail149066.authsmtp.net (outmail149066.authsmtp.net [62.13.149.66]) by mail.postgresql.org (Postfix) with ESMTP id 6C168133616B for ; Fri, 4 Feb 2011 17:22:37 -0400 (AST) Received: from mail-c193.authsmtp.com (mail-c193.authsmtp.com [62.13.128.118]) by punt8.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id p14LMaMU041022 for ; Fri, 4 Feb 2011 21:22:36 GMT Received: from Sidney-Stratton.local (dsl081-245-111.sfo1.dsl.speakeasy.net [64.81.245.111]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2) with ESMTP id p14LMTnn083456 for ; Fri, 4 Feb 2011 21:22:30 GMT Message-ID: <4D4C6E15.4080801@agliodbs.com> Date: Fri, 04 Feb 2011 13:22:29 -0800 From: Josh Berkus User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1b3pre) Gecko/20090223 Thunderbird/3.0b2 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: checkpoint_completion_target and Ext3 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Server-Quench: dfc03a2f-30a4-11e0-97bb-002264978518 X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkbIhBDJB8RWB5f NVxfJ1xYPXUEQkpF VCReGBUITgIzDi11 bxUnOFdCYEpPXhVo UUJLQFhRFEtuBQIJ BwAcVhxsdgRHZ3x1 Z0N9Xj4bXUAGCCIj HE5cFmkDYylna2dR BBYLdwAFclVXfR8U bk1+VSYNfGwANCh9 R1dpZW5tbGoPdX0F VAoNIFkRWUEKGCIL TBcHBTEiAUwCQRIv JgYpJ0JUFUAdemgi LQBJ X-Authentic-SMTP: 61633136333939.1014:706 X-AuthFastPath: 0 (Was 255) X-AuthVirus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201102/222 X-Sequence-Number: 42360 Greg (Smith), Given your analysis of fsync'ing behavior on Ext3, would you say that it is better to set checkpoint_completion_target to 0.0 on Ext3? -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com