Re: Opteron scaling with PostgreSQL - Mailing list pgsql-general

From Greg Stark
Subject Re: Opteron scaling with PostgreSQL
Date
Msg-id 87pt85s0r3.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Opteron scaling with PostgreSQL  (Steve Wolfe <nw@codon.com>)
Responses Re: Opteron scaling with PostgreSQL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Gregory S. Williamson"
Date:
Subject: Re: Trying to minimize the impact of checkpoints (resend)
Next
From: "Dann Corbit"
Date:
Subject: Re: Opteron scaling with PostgreSQL