Re: [GENERAL] Performance while loading data and indexing

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: [GENERAL] Performance while loading data and indexing
Дата
Msg-id m3ptv0ib90.fsf@varsoon.wireboard.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Performance while loading data and indexing  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: [GENERAL] Performance while loading data and indexing  (Mike Benoit <mikeb@netnation.com>)
Список pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:

> Doug McNaught wrote:
> > Tom Lane <tgl@sss.pgh.pa.us> writes:
> >
> > > We'd be happiest with a filesystem that journals its own metadata and
> > > not the user data in the file(s).  I dunno if there are any.
> >
> > ext3 with data=writeback?  (See my previous message to Bruce).
>
> OK, so that makes ext3 crash safe without lots of overhead?

Metadata is journaled so you shouldn't lose data blocks or directory
entries.  Some data blocks (that haven't been fsync()'ed) may have old
or wrong data in them, but I think that's the same as ufs, right?  And
WAL replay should take care of that.

It'd be very interesting to do some tests of the various journaling
modes.  I have an old K6 that I might be able to turn into a
hit-the-reset-switch-at-ramdom-times machine.  What kind of tests
should be run?

-Doug

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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Reconstructing FKs in pg_dump
Следующее
От: Joe Conway
Дата:
Сообщение: Re: About connectby() again