On Thu, Mar 13, 2008 at 05:27:09PM -0400, Greg Smith wrote:
I haven't found fdatasync to be significantly better in my tests on Linux but I never went out of my way to try and quantify it. My understanding is that some of the write barrier implementation details on ext3 filesystems make any sync call a relatively heavy operation but I haven't poked at the code yet to figure out why.
Which is why having the checkpoints on a seperate ext2 partition tends to be a nice win. (Even if its not on a seperate disk.)
Mike Stone -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
