Re: [GENERAL] Performance while loading data and indexing

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: [GENERAL] Performance while loading data and indexing
Дата
Msg-id 87n0q4zc0l.fsf@mailbox.samurai.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Performance while loading data and indexing  (Greg Copeland <greg@CopelandConsulting.Net>)
Ответы Re: [GENERAL] Performance while loading data and indexing  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: [GENERAL] Performance while loading data and indexing  (Curt Sampson <cjs@cynic.net>)
Список pgsql-hackers
Greg Copeland <greg@CopelandConsulting.Net> writes:
> On Thu, 2002-09-26 at 16:03, Neil Conway wrote:
> > I'm not really familiar with the reasoning behind ext2's
> > reputation as recovering poorly from crashes; if we fsync a WAL
> > record to disk before we lose power, can't we recover reliably,
> > even with ext2?
>
> Well, I have experienced data loss from ext2 before.  Also, recovery
> from crashes on large file systems take a very, very long time.

Yes, but wouldn't you face exactly the same issues if you ran a
UFS-like filesystem in asynchronous mode? Albeit it's not the default,
but performance in synchronous mode is usually pretty poor.

The fact that ext2 defaults to asynchronous mode and UFS (at least on
the BSDs) defaults to synchronous mode seems like a total non-issue to
me. Is there any more to the alleged difference in reliability?

Cheers,

Neil

--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC

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

Предыдущее
От: Rod Taylor
Дата:
Сообщение: Re: Reconstructing FKs in pg_dump
Следующее
От: Robert Treat
Дата:
Сообщение: Re: Reconstructing FKs in pg_dump