Bruce Momjian <[EMAIL PROTECTED]> writes: > Wow. That leaves no good Linux file system alternatives. > PostgreSQL just wants an ordinary file system that has reliable > recovery from a crash.
I'm not really familiar with the reasoning behind ext2's reputation as recovering poorly from crashes; if we fsync a WAL record to disk before we lose power, can't we recover reliably, even with ext2? > > > Also, though ext3 is slower, turning fsync off should make ext3 > > > function similar to ext2. > > > > Why would that be? > > I assumed it was the double fsync for the normal and journal that > made the journalling file systems slog. Well, a journalling file system would need to write a journal entry and flush that to disk, even if fsync is disabled -- whereas without fsync enabled, ext2 doesn't have to flush anything to disk. ISTM that the performance advantage of ext2 over ext3 is should be even larger when fsync is not enabled. Cheers, Neil -- Neil Conway <[EMAIL PROTECTED]> || PGP Key ID: DB3C29FC ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org