Re: [GENERAL] Performance while loading data and indexing - Mailing list pgsql-hackers

From Neil Conway
Subject Re: [GENERAL] Performance while loading data and indexing
Date
Msg-id 87n0q4zc0l.fsf@mailbox.samurai.com
Whole thread Raw
In response to Re: [GENERAL] Performance while loading data and indexing  (Greg Copeland <greg@CopelandConsulting.Net>)
Responses 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>)
List 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 by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Reconstructing FKs in pg_dump
Next
From: Robert Treat
Date:
Subject: Re: Reconstructing FKs in pg_dump