Kevin Grittner wrote:
> Bruce Momjian <bruce@momjian.us> wrote:
>
> > With a BBU you can turn off full_page_writes
>
> My understanding is that that is not without risk. What happens if
> the WAL is written, there is a commit, but the data page has not yet
> been written to the controller? Don't we still have a torn page?
I don't see how full_page_writes affect non-written pages to the
controller.
full_page_writes is designed to guard against a partial write to a
device. I don't think the raid cache can be partially written to, and
the cache will not be cleared until the drive has fully writen the data
to disk.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +