Re: no universally correct setting for fsync - Mailing list pgsql-hackers

From Craig Ringer
Subject Re: no universally correct setting for fsync
Date
Msg-id 4BE51BA5.70202@postnewspapers.com.au
Whole thread Raw
In response to Re: no universally correct setting for fsync  (Josh Berkus <josh@agliodbs.com>)
Responses Re: no universally correct setting for fsync
List pgsql-hackers
On 8/05/2010 1:56 AM, Josh Berkus wrote:
>
>> I never meant to suggest any statement in that section is factually
>> wrong; it's just all too rosy, leading people to believe it's no big
>> deal to turn it off.
>
> Yeah, that section is overdue for an update. I'll write some new text
> and post it to pgsql-docs.

It's probably worth mentioning that people who want to turn off fsync to 
gain a performance boost should instead look at a RAID controller with a 
BBU so they can safely enable write-back caching, getting most of the 
benefits of fsync=off safely.

--
Craig Ringer


pgsql-hackers by date:

Previous
From: Nikhil Sontakke
Date:
Subject: Re: possible memory leak with SRFs
Next
From: Simon Riggs
Date:
Subject: Re: max_standby_delay considered harmful