Re: WAL sync behaviour

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: WAL sync behaviour
Дата
Msg-id 1131637958.3554.75.camel@state.g2switchworks.com
обсуждение исходный текст
Ответ на Re: WAL sync behaviour  (Michael Stone <mstone+postgres@mathom.us>)
Ответы Re: WAL sync behaviour  (Michael Stone <mstone+postgres@mathom.us>)
Re: WAL sync behaviour  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Thu, 2005-11-10 at 08:43, Michael Stone wrote:
> On Thu, Nov 10, 2005 at 03:25:35PM +0100, Steinar H. Gunderson wrote:
> >Ah, yes, I forgot -- it's ext3. We're considering simply moving the WAL onto
> >a separate partition (with data=writeback and noatime) if that can help us
> >any.
>
> There's no reason to use a journaled filesystem for the wal. Use ext2 in
> preference to ext3.

Not from what I understood.  Ext2 can't guarantee that your data will
even be there in any form after a crash.  I believe only metadata
journaling is needed though.

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Some help on buffers and other performance tricks
Следующее
От: Michael Stone
Дата:
Сообщение: Re: WAL sync behaviour