Re: SAN and full_page_writes

Поиск
Список
Период
Сортировка
От Nikolas Everett
Тема Re: SAN and full_page_writes
Дата
Msg-id d4e11e980809080817l4f29c647s2e4485451c5e62c1@mail.gmail.com
обсуждение исходный текст
Ответ на Re: SAN and full_page_writes  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-performance
Дерево обсуждения
On Mon, Sep 8, 2008 at 10:59 AM, Gregory Stark <stark@enterprisedb.com> wrote:

That "media recovery" it's referring to sounds like precisely our WAL full
page writes...


--
 Gregory Stark
 EnterpriseDB          http://www.enterprisedb.com
 Ask me about EnterpriseDB's PostGIS support!

That sounds right.

So the take home from this is that NetApp does its best to protect you from partial page writes but comes up short on untweaked NFS (see doc to tweak.)  Otherwise you are protected so long as your OS and file system implement fsync properly.

--Nik

В списке pgsql-performance по дате отправления:

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: SAN and full_page_writes
Следующее
От: "Matt Smiley"
Дата:
Сообщение: Re: inaccurate stats on large tables