On Sun, Mar 26, 2006 at 04:58:34PM -0800, Chris Wedgwood wrote:
> On Sun, Mar 26, 2006 at 09:18:28AM -0500, Justin Piszcz wrote:
> > Does anyone have any benchmarks for the XFS filesystem contrasted
> > with the amount of fragmentation on the disk? I have spoken with
> > someone who believes defragmenting filesystems with XFS is probably
> > a waste of time unless there are benchmarks to back it up.
>
> it depends, badly fragmented files do hurt performance if it's
> pathalogically bad, i've worked with a couple of people who do real
> time video to help reduce this and the differences can be enourmous
I've seen a production PostgreSQL database file get REALLY fragmented
and noticably slow because of how massive amounts of data would be
INSERTed and DELETEd on a regular basis. We could have circumvented this
by having a regular xfs_fsr job, or a regular VACUUM job, but neither
was enabled. In hindsight, both should have been enabled. ;)
--> Jijo
--
Federico Vicente C. Sevilla III
Information Technology Consultant
Q Software Research Corporation
Website: http://jijo.free.net.ph
|