Re: Migration study, step 1: bulk write performance

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: Migration study, step 1: bulk write performance
Дата
Msg-id 20060321120158.GO15742@pervasive.com
обсуждение исходный текст
Ответ на Re: Migration study, step 1: bulk write performance  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
Ответы Re: Migration study, step 1: bulk write performance  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
Re: Migration study, step 1: bulk write performance  (Michael Stone <mstone+postgres@mathom.us>)
Список pgsql-performance
On Tue, Mar 21, 2006 at 12:56:18PM +0100, Steinar H. Gunderson wrote:
> On Tue, Mar 21, 2006 at 12:52:46PM +0100, Csaba Nagy wrote:
> > They knew however that for the data partitions no FS journaling is
> > needed, and for the WAL partition meta data journaling is enough, so I
> > guess they tuned ext3 for this.
>
> For the record, that's the wrong way round. For the data partitioning
> metadata journaling is enough, and for the WAL partition you don't need any
> FS journaling at all.

Are you sure? Metadate changes are probably a lot more common on the WAL
partition. In any case, I don't see why there should be a difference.
The real issue is: is related filesystem metadata sync'd as part of a
file being fsync'd?
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

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

Предыдущее
От: Csaba Nagy
Дата:
Сообщение: Re: Migration study, step 1: bulk write performance
Следующее
От: "Steinar H. Gunderson"
Дата:
Сообщение: Re: Migration study, step 1: bulk write performance