Re: WAL sync behaviour

Поиск
Список
Период
Сортировка
От Michael Stone
Тема Re: WAL sync behaviour
Дата
Msg-id 20051110160054.GP9905@mathom.us
обсуждение исходный текст
Ответ на Re: WAL sync behaviour  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список pgsql-performance
On Thu, Nov 10, 2005 at 09:52:38AM -0600, Scott Marlowe wrote:
>Not from what I understood.  Ext2 can't guarantee that your data will
>even be there in any form after a crash.

It can if you sync the data. (Which is the whole point of the WAL.)

>I believe only metadata journaling is needed though.

If you don't sync, metadata journaling doesn't do anything to guarantee
that your data will be there, so you're adding no data security in the
non-synchronous-write case. (Which is irrelevant for the WAL.)

What metadata journalling gets you is fast recovery from crashes by
avoiding a fsck. The fsck time is related to the number of files on a
filesystem--so it's generally pretty quick on a WAL partition anyway.

Mike Stone

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: WAL sync behaviour
Следующее
От: Ron Peacetree
Дата:
Сообщение: Re: Sort performance on large tables