X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id CC366CC00C for ; Fri, 18 Jul 2003 16:00:15 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 76893-01 for ; Fri, 18 Jul 2003 16:00:46 +0000 (GMT) Received: from mail2.mediadesign.nl (md2.mediadesign.nl [212.19.205.67]) by svr1.postgresql.org (Postfix) with SMTP id 1F9D9CCCE9 for ; Fri, 18 Jul 2003 13:00:12 -0300 (ADT) Received: (qmail 24973 invoked by uid 666); 18 Jul 2003 16:00:43 -0000 Date: Fri, 18 Jul 2003 18:00:43 +0200 From: Vincent van Leeuwen To: pgsql-performance@postgresql.org Subject: Re: Sanity check requested Message-ID: <20030718160042.GV21071@md2.mediadesign.nl> Mail-Followup-To: pgsql-performance@postgresql.org References: <3F13E18A.21241.4B86CB0@localhost> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.3.28i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/296 X-Sequence-Number: 2589 On 2003-07-17 10:41:35 -0500, Nick Fankhauser wrote: > I'm using ext2. For now, I'll leave this and the OS version alone. If I > I'd upgrade to a journaling filesystem as soon as possible for reliability. Testing in our own environment has shown that PostgreSQL performs best on ext3 (yes, better than XFS, JFS or ReiserFS) with a linux 2.4.21 kernel. Be sure to mount noatime and to create the ext3 partition with the correct stripe size of your RAID array using the '-R stride=foo' option (see man mke2fs). Vincent van Leeuwen Media Design - http://www.mediadesign.nl/