| From: | "Jeffrey D(dot) 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> |
| Subject: | Re: ext3 filesystem / linux 7.3 |
| Date: | 2003-04-01 20:42:54 |
| Message-ID: | 093201c2f88f$45e60730$0b02a8c0@pointhere.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keith Bottner | 2003-04-01 20:43:35 | Re: ext3 filesystem / linux 7.3 |
| Previous Message | Tom Lane | 2003-04-01 20:21:43 | Re: Postgresql performance on Solaris |