| From: | Michael Tokarev <mjt(at)tls(dot)msk(dot)ru> |
|---|---|
| To: | David Dougall <davidd(at)et(dot)byu(dot)edu> |
| Cc: | Arshavir Grigorian <ag(at)m-cam(dot)com>, linux-raid(at)vger(dot)kernel(dot)org, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Postgres on RAID5 |
| Date: | 2005-03-16 16:55:49 |
| Message-ID: | 42386515.1070103@tls.msk.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Gagnon | 2005-03-16 17:02:04 | Re: Performance problem on delete from for 10k rows. May |
| Previous Message | David Dougall | 2005-03-16 16:47:35 | Re: Postgres on RAID5 |