Re: SAN and full_page_writes - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: SAN and full_page_writes
Date
Msg-id 200809061946.m86JkeS01341@momjian.us
Whole thread Raw
In response to Re: SAN and full_page_writes  ("Nikolas Everett" <nik9000@gmail.com>)
Responses Re: SAN and full_page_writes
List pgsql-performance
Nikolas Everett wrote:
> I seem to have answered my own question.  I'm sending the answer to the list
> in case someone else has the same question one day.
>
> According to the NetApp documentation, it does protect me from partial page
> writes.  Thus, full_page_writes = off.

Just for clarification, the NetApp must guarantee that the entire 8k
gets to disk, not just one of the 512-byte blocks that disks use
internally.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: You may need to increase mas_loks_per_trasaction
Next
From: Axel Rau
Date:
Subject: performance impact of non-C locale