public inbox for [email protected]  

help / color / mirror / Atom feed

From: Andrew Dunstan <[email protected]>
To: Kevin Grittner <[email protected]>
Cc: [email protected]
Subject: Re: no universally correct setting for fsync
Date: Fri, 07 May 2010 10:38:47 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>



Kevin Grittner wrote:
>  
> There are dire-sounding statements interspersed with:
>  
> | using fsync results in a performance penalty
>  
> | Due to the risks involved, there is no universally correct setting
> | for fsync.
>  
> | If you trust your operating system, your hardware, and your
> | utility company (or your battery backup), you can consider
> | disabling fsync.
>  
> Isn't this a little too rosy a picture to paint?
>  
>
>   

I think the critical question is really whether you are prepared to lose 
your database.

I have a customer who rotates databases in and out of line, and 
processes major updates on the out of line database. If they lose the 
database occasionally they are prepared to wear that risk for the 
performance gain they get from running with fsync off. It just means 
that they have to recover and so the inline database will get a bit 
staler than usual while they do.

So I think its true that there is no universally right answer. Maybe the 
criteria mentioned in the last para need tweaking some, though. It's not 
just a matter of trusting hardware etc. I have seen mishaps when idiots 
knock out power cords and the like. The unexpected does sometime happen, 
despite the best planning.

cheers

andrew

view thread (35+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: no universally correct setting for fsync
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox