> I have slave dbs running on four 7200RPM SATA drives with fsync off. > They only get updated from the master db so if they go boom, I just > recreate their node. There's times fsync off is ok, you just have to > know that that db is now considered "disposable". > > However, I'd suggest doing some benchmarking to PROVE that you're > seeing an improvement from fsync being off. If there's no > improvement, then you might as well leave it on and save yourself some > headache later on when the machine gets powered off suddenly etc.
I haven't been involved in any benchmarking of PG8 with fsync=off, but we certainly did it with PG 7.4. fsync=0ff, for our purposes, was MUCH faster. > -- > Sent via pgsql-performance mailing list > (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
