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 651C13A5607 for ; Tue, 11 Jan 2005 09:24:16 +0000 (GMT) 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 50600-04 for ; Tue, 11 Jan 2005 09:24:05 +0000 (GMT) Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.250.190.2]) by svr1.postgresql.org (Postfix) with ESMTP id A12C73A55F9 for ; Tue, 11 Jan 2005 09:24:06 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 4A0553158F; Tue, 11 Jan 2005 10:24:06 +0100 (MET) From: "Pete de Zwart" X-Newsgroups: pgsql.performance Subject: Best filesystem for PostgreSQL Database Cluster under Linux Date: Tue, 11 Jan 2005 20:23:25 +1100 Organization: Froob Networks X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2527 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 X-RFC2646: Format=Flowed; Original Lines: 24 Message-ID: <41e39b04$0$96857$c30e37c6@ken-reader.news.telstra.net> To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.185 tagged_above=0 required=5 tests=PRIORITY_NO_NAME X-Spam-Level: * X-Archive-Number: 200501/176 X-Sequence-Number: 9866 Greetings to one and all, I've been trying to find some information on selecting an optimal filesystem setup for a volume that will only contain a PostgreSQL Database Cluster under Linux. Searching through the mailing list archive showed some promising statistics on the various filesystems available to Linux, ranging from ext2 through reiserfs and xfs. I have come to understand that PostgreSQLs Write Ahead Logging (WAL) performs a lot of the journal functionality provided by the majoirty of contemporary filesystems and that having both WAL and filesystem journalling can degrade performance. Could anyone point me in the right direction so that I can read up some more on this issue to discern which filesystem to choose and how to tune both the FS and PostgreSQL so that they can compliment each other? I've attempted to find this information via the FAQ, Google and the mailing list archives but have lucked out for the moment. Regards, Pete de Zwart.