Re: SAN and full_page_writes

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: SAN and full_page_writes
Дата
Msg-id 200809061946.m86JkeS01341@momjian.us
обсуждение исходный текст
Ответ на Re: SAN and full_page_writes  ("Nikolas Everett" <nik9000@gmail.com>)
Ответы Re: SAN and full_page_writes
Список 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 по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: You may need to increase mas_loks_per_trasaction
Следующее
От: Axel Rau
Дата:
Сообщение: performance impact of non-C locale