Re: Opteron scaling with PostgreSQL

Steve Wolfe <nw@codon.com> writes:

>    I've run with fsync off on my production servers for years.  Power never
> goes off, and RAID 5 protects me from disk failures.  Sooner or later, it may
> bite me in the butt.  We make backups sufficiently often that the small amount
> of data we'll lose will be far offset by the tremendous performance boost that
> we've enjoyed.  In fact, we even have a backup server sitting there doing
> nothing, which can take over the duties of the main DB server within a VERY
> short amount of time.

That's good, because you'll eventually need it.

All it will take will be a Linux crash for the database files on disk to
become corrupted. No amount of UPS or RAID protection will protect from that.

--
greg