Re: no universally correct setting for fsync
Michael Tharp <gxti@partiallystapled.com>
From: Michael Tharp <gxti@partiallystapled.com>
To: Craig Ringer <craig@postnewspapers.com.au>
Cc: pgsql-hackers@postgresql.org
Date: 2010-05-10T14:48:01Z
Lists: 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