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 734C252816 for ; Fri, 3 Jun 2005 07:41:32 -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 09291-10 for ; Fri, 3 Jun 2005 10:41:23 +0000 (GMT) Received: from linda-4.paradise.net.nz (bm-4a.paradise.net.nz [202.0.58.23]) by svr1.postgresql.org (Postfix) with ESMTP id 638625280A for ; Fri, 3 Jun 2005 07:41:22 -0300 (ADT) Received: from smtp-1.paradise.net.nz (smtp-1a.paradise.net.nz [202.0.32.194]) by linda-4.paradise.net.nz (Paradise.net.nz) with ESMTP id <0IHI00EPX8D0L8@linda-4.paradise.net.nz> for pgsql-performance@postgresql.org; Fri, 03 Jun 2005 22:41:24 +1200 (NZST) Received: from [192.168.1.11] (218-101-13-183.paradise.net.nz [218.101.13.183]) by smtp-1.paradise.net.nz (Postfix) with ESMTP id 60E7782CF6; Fri, 03 Jun 2005 22:41:24 +1200 (NZST) Date: Fri, 03 Jun 2005 22:41:22 +1200 From: Mark Kirkwood Subject: Re: Filesystem In-reply-to: <1117782401.4380.37.camel@fandelm.ecommit.de> To: Martin Fandel Cc: pgsql-performance@postgresql.org Message-id: <42A033D2.3080609@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7bit X-Accept-Language: en-us, en User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050511) References: <1117782401.4380.37.camel@fandelm.ecommit.de> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.162 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/66 X-Sequence-Number: 12704 Martin Fandel wrote: > Hi @ all, > > i have only a little question. Which filesystem is preferred for > postgresql? I'm plan to use xfs (before i used reiserfs). The reason > is the xfs_freeze Tool to make filesystem-snapshots. > > Is the performance better than reiserfs, is it reliable? > I used postgresql with xfs on mandrake 9.0/9.1 a while ago - reliability was great, performance seemed better than ext3. I didn't compare with reiserfs - the only time I have ever lost data from a Linux box has been when I used reiserfs, hence I am not a fan :-( best wishes Mark