Re: performance config help

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