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

From Michael Tharp
Subject Re: no universally correct setting for fsync
Date
Msg-id 4BE81CA1.4080201@partiallystapled.com
Whole thread Raw
In response to Re: no universally correct setting for fsync  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: no universally correct setting for fsync
List pgsql-hackers
On 05/08/2010 04:07 AM, Craig Ringer wrote:
> 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.

Which options specifically should be set if a BBU is in use? Obviously 
fsync should be on always, but can full_page_writes be disabled? Are 
there other tweaks that can be done?

It would be great to see some practical hints in the documentation while 
the fsync part is getting changed.

-- m. tharp


pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: max_standby_delay considered harmful
Next
From: Bruce Momjian
Date:
Subject: Re: max_standby_delay considered harmful