On Dec 6, 2007 12:08 AM, <[EMAIL PROTECTED]> wrote: > XFS is a great filesystem and I recommend it to all. However, xfs_fsr > would most likely be unable to defrag an actively used (written to) file > such as a database table.
Unless PostgreSQL mmaps it's data files (anyone know for sure? I don't think it does) xfs_fsr will defrag files just fine. Someone running that combo can run xfs_fsr in verbose mode to check. Obviously, it's not a bad idea to try to schedule it for a period of low activity. :-) -Dave