X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5B15CD768F for ; Thu, 25 Aug 2005 16:00:25 -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 67926-03 for ; Thu, 25 Aug 2005 19:00:23 +0000 (GMT) Received: from tbmail.tradebot.com (Tradebot-Systems-1096753.cust-rtr.swbell.net [68.90.170.2]) by svr1.postgresql.org (Postfix) with ESMTP id 48D44D768E for ; Thu, 25 Aug 2005 16:00:22 -0300 (ADT) Received: from 192.168.200.29 ([192.168.200.29]) by tbmail.tradebot.com ([192.168.1.50]) with Microsoft Exchange Server HTTP-DAV ; Thu, 25 Aug 2005 19:00:22 +0000 Received: from krb06 by TBMAIL; 25 Aug 2005 14:00:22 -0500 Subject: Re: Need for speed 2 From: Kelly Burkhart To: Ron Cc: pgsql-performance@postgresql.org In-Reply-To: <6.2.3.4.0.20050825094630.05e6b160@pop.earthlink.net> References: <6.2.3.4.0.20050817140116.05d317b0@pop.earthlink.net> <430D6EED.10603@relevanttraffic.se> <6.2.3.4.0.20050825094630.05e6b160@pop.earthlink.net> Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Thu, 25 Aug 2005 14:00:22 -0500 Message-Id: <1124996422.6969.47.camel@krb06.tradebot.com> Mime-Version: 1.0 X-Mailer: Evolution 2.2.1 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 required=5 tests=[FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200508/419 X-Sequence-Number: 14166 On Thu, 2005-08-25 at 11:16 -0400, Ron wrote: > ># - Settings - > > > >fsync = false # turns forced synchronization on or off > >#wal_sync_method = fsync # the default varies across platforms: > > # fsync, fdatasync, open_sync, or > > I hope you have a battery backed write buffer! Battery backed write buffer will do nothing here, because the OS is taking it's sweet time flushing to the controller's battery backed write buffer! Isn't the reason for batter backed controller cache to make fsync()s fast? -K