Re: SAN and full_page_writes

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: SAN and full_page_writes
Дата
Msg-id 200809082235.m88MZOb09974@momjian.us
обсуждение исходный текст
Ответ на Re: SAN and full_page_writes  ("Nikolas Everett" <nik9000@gmail.com>)
Список pgsql-performance
Nikolas Everett wrote:
> Thanks for pointing that out Bruce.
>
> NetApp has a 6 page PDF about NetApp and databases.  On page 4:
>
> As discussed above, reads and writes are unconditionally atomic to 64 KB.
> While reads or writes
> may fail for a number of reasons (out of space, permissions, etc.), the
> failure is always atomic to
> 64 KB. All possible error conditions are fully evaluated prior to committing
> any updates or
> returning any data to the database.

Well, that is certainly good news, and it is nice the specified the atomic
size.

--
  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 по дате отправления:

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: bitmap heap scan versus simple index and nested loop
Следующее
От: Greg Smith
Дата:
Сообщение: Intel's X25-M SSD