Re: [HACKERS] fsync vs open_sync

Guys, just so you know:

OSDL did some testing and found Ext3 to be perhaps the worst FS for PostgreSQL
-- although this testing was with the default options.   Ext3 involved an
almost 40% write performance penalty compared with Ext2, whereas the penalty
for ReiserFS and JFS was less than 10%.

This concurs with my personal experience.

--
Josh Berkus
Aglio Database Solutions
San Francisco