Re: Dangers of fsync = off - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Dangers of fsync = off
Date
Msg-id 20070508140921.GG2735@phlogiston.dyndns.org
Whole thread Raw
In response to Re: Dangers of fsync = off  (Joel Dice <dicej@mailsnare.net>)
Responses Re: Dangers of fsync = off
List pgsql-general
On Fri, May 04, 2007 at 08:54:10AM -0600, Joel Dice wrote:
>
> My next question is this: what are the dangers of turning fsync off in the
> context of a high-availablilty cluster using asynchronous replication?

My real question is why you want to turn it off.  If you're using a
battery-backed cache on your disk controller, then fsync ought to be
pretty close to free.  Are you sure that turning it off will deliver
the benefit you think it will?

> on Y.  Thus, database corruption on X is irrelevant since our first step
> is to drop them.

Not if the corruption introduces problems for replication, which is
indeed possible.

A
--
Andrew Sullivan  | ajs@crankycanuck.ca
A certain description of men are for getting out of debt, yet are
against all taxes for raising money to pay it off.
        --Alexander Hamilton

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: are foreign keys realized as indexes?
Next
From: Jim Nasby
Date:
Subject: Re: PITR and tar