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 A748514B281E for ; Tue, 10 Aug 2004 14:48:24 -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 43532-03 for ; Tue, 10 Aug 2004 17:48:19 +0000 (GMT) Received: from outland.mohawksoft.com (unknown [64.46.156.80]) by svr1.postgresql.org (Postfix) with ESMTP id CCA2D14B2827 for ; Tue, 10 Aug 2004 14:48:12 -0300 (ADT) Received: (from mohawk@localhost) by outland.mohawksoft.com (8.11.6/8.11.6) id i7AI4rQ11357; Tue, 10 Aug 2004 14:04:53 -0400 From: pgsql@mohawksoft.com X-Authentication-Warning: outland.mohawksoft.com: mohawk set sender to pgsql@mohawksoft.com using -f Received: from 64.119.142.34 (SquirrelMail authenticated user pgsql) by mail.mohawksoft.com with HTTP; Tue, 10 Aug 2004 14:04:52 -0400 (EDT) Message-ID: <33646.64.119.142.34.1092161092.squirrel@mail.mohawksoft.com> In-Reply-To: <200408101018.32327.josh@agliodbs.com> References: <6EE64EF3AB31D5448D0007DD34EEB3412A7446@Herge.rcsinc.local> <200408101018.32327.josh@agliodbs.com> Date: Tue, 10 Aug 2004 14:04:52 -0400 (EDT) Subject: Re: [HACKERS] fsync vs open_sync To: "Josh Berkus" Cc: "Merlin Moncure" , pgsql-performance@postgresql.org User-Agent: SquirrelMail/1.4.2 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME, PRIORITY_NO_NAME X-Spam-Level: * X-Archive-Number: 200408/207 X-Sequence-Number: 7843 > Guys, just so you know: > > OSDL did some testing and found Ext3 to be perhaps the worst FS for > PostgreSQL > -- although this testing was with the default options. Ext3 involved an > almost 40% write performance penalty compared with Ext2, whereas the > penalty > for ReiserFS and JFS was less than 10%. > > This concurs with my personal experience. I had exactly the same experience