X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E5951475CBC for ; Tue, 1 Apr 2003 15:36:47 -0500 (EST) Received: from localhost.localdomain (208-41-234-242.client.dsl.net [208.41.234.242]) by postgresql.org (Postfix) with ESMTP id E6E2D475AF8 for ; Tue, 1 Apr 2003 15:36:46 -0500 (EST) Received: from endeavour (endeavour.pointhere.net [192.168.2.11]) by localhost.localdomain (8.11.6/8.11.6) with SMTP id h31KPDr11175; Tue, 1 Apr 2003 15:25:13 -0500 Message-ID: <093201c2f88f$45e60730$0b02a8c0@pointhere.net> Reply-To: "Jeffrey D. Brower" From: "Jeffrey D. Brower" To: "Bruce Momjian" , "eric soroos" Cc: "Shankar K" , References: <200304011826.h31IQ2S29201@candle.pha.pa.us> Subject: Re: ext3 filesystem / linux 7.3 Date: Tue, 1 Apr 2003 15:42:54 -0500 Organization: A Basic Marketing Company MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Spam-Status: No, hits=-6.5 required=5.0 tests=BAYES_30,RCVD_IN_NJABL,REFERENCES,X_NJABL_OPEN_PROXY autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/10 X-Sequence-Number: 1516 OK so am I hearing: XFS is the fastest (but is it the safest?) but does not come on Linux. Ext2 does less work than Ext3 so is fastest among what DOES come with Linux - but if you have a crash that fsck can't fix you're hosed. Ext3 is quite a bit slower if set to be real safe, a wee bit slower if run with standard options which makes it more crash-safe, and much slower if the mount flags are set to metadata journaling but that is much safer as a file system because the metadata journaling is complementary to the PG transactioning. To determine which you want you must choose which one feels to you like the right balance of speed and the setup work you are willing to perform and maintain. Do I have it right? Jeff