From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: Jeffrey D. Brower <jeff@pointhere.net>
To: Bruce Momjian <pgman@candle.pha.pa.us>
To: eric soroos <eric-psql@soroos.net>
Cc: Shankar K <shan0075@yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: ext3 filesystem / linux 7.3
Date: Wed, 2 Apr 2003 09:33:56 +0800
Message-ID: <061501c2f8b7$f5280720$6500a8c0@fhp.internal> (raw)
References: <200304011826.h31IQ2S29201@candle.pha.pa.us>
<093201c2f88f$45e60730$0b02a8c0@pointhere.net>
Just switch to FreeBSD and use UFS ;)
Chris
----- Original Message -----
From: "Jeffrey D. Brower" <jeff@pointhere.net>
To: "Bruce Momjian" <pgman@candle.pha.pa.us>; "eric soroos" <eric-psql@soroos.net>
Cc: "Shankar K" <shan0075@yahoo.com>; <pgsql-performance@postgresql.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@postgresql.org so that your
> message can get through to the mailing list cleanly
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: chriskl@familyhealth.com.au, jeff@pointhere.net, pgman@candle.pha.pa.us, eric-psql@soroos.net, shan0075@yahoo.com
Subject: Re: ext3 filesystem / linux 7.3
In-Reply-To: <061501c2f8b7$f5280720$6500a8c0@fhp.internal>
References: <200304011826.h31IQ2S29201@candle.pha.pa.us> <093201c2f88f$45e60730$0b02a8c0@pointhere.net> <061501c2f8b7$f5280720$6500a8c0@fhp.internal>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox