On Thu, 5 Apr 2007, [EMAIL PROTECTED] wrote:
I'm curious to know why you're on xfs (i've been too chicken to stray from ext3).
better support for large files (although postgres does tend to try and keep the file size down by going with multiple files) and also for more files
the multiple levels of indirection that ext3 uses for accessing large files (or large directories) can really slow things down, just from the overhead of looking up the metadata (including finding where the actual data blocks are on disk)
ext4 is planning to address this and will probably be a _very_ good improvement, but ext3 has very definiate limits that it inherited from ext2.
David Lang ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
