Let me chime in here for a moment. My objective is not to bash any filesystem technology. I have been using XFS consistently now for a couple of years on all my Linux boxes. It works great. I love the spead and performance. A number of years ago when it was first being ported to Linux I tried it out and I will say it had a number of problems (occasionally lose data and files) but they seemed to have been fixed. I am using XFS on a production (Fedora Core 3) PostgreSQL 7.4.6 box without any problems. That is all I have to say on the matter. Juan -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Marco Colombo Sent: Friday, February 04, 2005 12:30 PM To: Joshua D. Drake Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Best Linux Distribution On Thu, 20 Jan 2005, Joshua D. Drake wrote: >> Is there any evidence of the above claim? I've seen a link to a l-k >> bug report about ext3, but apparently it was totally unconfirmed (and >> a single bug does not mean a FS is not good - I remember XFS being >> hammered heavily before being accepted into Linux). > > EXT3 works. It is just dog slow and yes there is plenty of evidence to > EXT3s problems. Even from the author himself. Just review the kernel > threads and mailing lists. Note that a lot of the problem have been fixed. It's just that EXT3 bugs are exposed, and discussed in the wild. Again, please provide this "evidence", expecially for the "dog slow" part. As for problems, I don't count bugs, expecially already fixed ones, as problems. A "problem" to me is something you can't correct and have to live with it. As a design flaw. EXT3 for sure has a huge user base, compared to XFS, so counting the number of bug reports on linux-kernel is meaningless, since XFS is a _recent_ addition to the mainstream kernel. >> I'm using ext3 cause all other FSes are simple add-ons in linux.All >> of them struggled a lot before being able to meet linux high quality >> standards and being accepted into mainstream. Ext3 was there from the >> start. Of course that doesn't mean it fits PostgreSQL needs better >> than other FSes. > > Well that isnt exactly true. EXT3 is a bolt on to EXT2 which was > always there. Reiser is also a long time kernel at least from 2.2. XFS > is also a long time Linux supporter and its inclusion into the main > tree had nothing to do with quality. > > Just because something isn't in the main tree doesn't mean that the > quality is lacking. A lot of times it is just politics. Interesting point of view. When it comes to filesystems, I tend to trust Al Viro's (linux VFS and generic filesystems mantainer) opinion. http://lkml.org/lkml/2003/12/2/150 "bloated", "[locking] it's a fscking mess", "long past the point where maintainers had lost any control over it". I see no politics in that. Just plain technical concerns about code quality. That was only one year ago. Anyway, XFS got merged, so I guess now it's up to tolerable quality, I hope. But still I don't like this: http://oss.sgi.com/projects/xfs/faq.html#nulls It seems it journals only metadata. You need _all_ processes in your system to use fsync or the O_SYNC flag. Otherwise you're going to _loose data_. There's no mount option about that. Compare EXT3 mount options: data=journal, data=ordered, data=writeback. It seems XFS only supports something similar to data=writeback. EXT3 default mode is data=ordered: "All data is forced directly out to the main file system prior to its metadata being committed to the journal." No wonder EXT3 (in default mode) may result slower than XFS, it's comparing oranges with apples. PostgreSQL users might not be affected, if they run with fsync on. If the application forces sync operations, I doubt there's any measurable difference between the two filesystems. The storage will be the bottleneck. > There is a reason that all major distributions supported XFS, Reiser > and JFS before RedHat and it has nothing to do with quality. Yes, user demand. Many distros support broken drivers, unstables patches, and lots of stuff that doesn't make it for the vanilla kernel, due to quality concerns. So you're right. It has nothing to do with quality... EXT3 and XFS have quite different feature sets, and I think both are a valid choice for PostgreSQL systems. Choose depending on your needs. But, please stop spreading FUD about EXT3, unless you provide direct links to "evidence". Generic "search the lists" isn't enough, I could say the same about XFS, and any other FS, of course. No software is born perfect. .TM. -- ____/ ____/ / / / / Marco Colombo ___/ ___ / / Technical Manager / / / ESI s.r.l. _____/ _____/ _/ Colombo@xxxxxx ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
