Robert Haas <robertmh...@gmail.com> writes: > Oh, I missed that. Actually, I wasn't really so concerned with > whether his benchmark is correct. I *am* concerned about being broken > out of the box on MacOS X.
Actually, the problem with OSX is that OSX is broken out of the box, at least by that standard. The system's normal configuration is that fsync() does nothing, so it's hardly surprising that O_DSYNC is no better. You have to use wal_sync_method = fsync_writethrough to get actual bits-to-the-platter behavior. I'm not sure whether we should select fsync_writethrough as the default on OSX. We don't make an equivalent attempt to prevent OS or storage malfeasance on other Unixoid platforms --- in fact, I'd say OSX is a bit ahead of the game in that you *can* force writethrough without resorting to arcane hacks with hdparm or some such. We could definitely stand to be a bit more verbose about documenting the platform-specific issues in this area. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers