Re: Postgres on RAID5 - Mailing list pgsql-performance

From Michael Tokarev
Subject Re: Postgres on RAID5
Date
Msg-id 42386515.1070103@tls.msk.ru
Whole thread Raw
In response to Re: Postgres on RAID5  (David Dougall <davidd@et.byu.edu>)
List pgsql-performance
David Dougall wrote:
> In my experience, if you are concerned about filesystem performance, don't
> use ext3.  It is one of the slowest filesystems I have ever used
> especially for writes.  I would suggest either reiserfs or xfs.

I'm a bit afraid to start yet another filesystem flamewar, but.
Please don't make such a claims without providing actual numbers
and config details.  Pretty please.

ext3 performs well for databases, there's no reason for it to be
slow.  Ok, enable data=journal and use it with eg Oracle - you will
see it is slow.  But in that case it isn't the filesystem to blame,
it's operator error, simple as that.

And especially reiserfs, with its tail packing enabled by default,
is NOT suitable for databases...

/mjt

pgsql-performance by date:

Previous
From: "Ruth Ivimey-Cook"
Date:
Subject: Effect of Stripe Size (was Postgres on RAID5)
Next
From: "Rosny"
Date:
Subject: Which one is faster: one way reading ="single pass reading"