> 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
ourpurposes, 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
>
