Messages in this thread | | | From | Andreas Dilger <> | Date | Wed, 27 Mar 2002 11:02:47 -0700 | Subject | Re: Filesystem benchmarks: ext2 vs ext3 vs jfs vs minix |
| |
On Mar 27, 2002 14:47 +0000, Matthew Kirkwood wrote: > Postgres doesn't pre-allocate datafiles. They reckon it's not > their job to implement a filesystem, and I'm inclined to agree. > They do prefer fdatasync on datafiles and (I think) O_DATASYNC > for their journal files where available, but I haven't checked > that my build is doing that.
If the I/O is normally sync driven, you should consider testing ext3 with "data=journal". While this seems counterintuitive because it is writing the data to disk twice, it can often be faster in real-world "bursty" environments because the sync I/O goes to the journal in one contiguous write, and it can then be written to the rest of the fs asynchronously safely. You can also set up an external journal device so that the journal is on another disk and avoid seeking between the journal and the rest of the filesystem.
Cheers, Andreas -- Andreas Dilger \ "If a man ate a pound of pasta and a pound of antipasto, \ would they cancel out, leaving him still hungry?" http://www-mddsp.enel.ucalgary.ca/People/adilger/ -- Dogbert
- To unsubscribe from this list: send the line "unsubscribe linux-kernel" in the body of a message to majordomo@vger.kernel.org More majordomo info at http://vger.kernel.org/majordomo-info.html Please read the FAQ at http://www.tux.org/lkml/
| |