From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | "Jeffrey D(dot) Brower" <jeff(at)pointhere(dot)net>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "eric soroos" <eric-psql(at)soroos(dot)net> |
Cc: | "Shankar K" <shan0075(at)yahoo(dot)com>, <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: ext3 filesystem / linux 7.3 |
Date: | 2003-04-02 01:33:56 |
Message-ID: | 061501c2f8b7$f5280720$6500a8c0@fhp.internal |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Just switch to FreeBSD and use UFS ;)
Chris
----- Original Message -----
From: "Jeffrey D. Brower" <jeff(at)pointhere(dot)net>
To: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>; "eric soroos" <eric-psql(at)soroos(dot)net>
Cc: "Shankar K" <shan0075(at)yahoo(dot)com>; <pgsql-performance(at)postgresql(dot)org>
Sent: Wednesday, April 02, 2003 4:42 AM
Subject: Re: [PERFORM] ext3 filesystem / linux 7.3
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sean Chittenden | 2003-04-02 01:49:06 | Re: ext3 filesystem / linux 7.3 |
Previous Message | scott.marlowe | 2003-04-01 21:42:59 | Re: Postgresql performance on Solaris |