Re: no universally correct setting for fsync

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: no universally correct setting for fsync
Date: 2010-05-08 08:07:01
Message-ID: 4BE51BA5.70202@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs 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

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Kevin Grittner 2010-05-08 13:09:51 Re: [HACKERS] no universally correct setting for fsync
Previous Message Josh Berkus 2010-05-08 00:17:53 Re: [HACKERS] no universally correct setting for fsync

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2010-05-08 08:44:12 Re: max_standby_delay considered harmful
Previous Message Nikhil Sontakke 2010-05-08 04:06:50 Re: possible memory leak with SRFs