| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | Greg Copeland <greg(at)CopelandConsulting(dot)Net> |
| Cc: | Neil Conway <neilc(at)samurai(dot)com>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, shridhar_daithankar(at)persistent(dot)co(dot)in, PostgresSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>, PostgresSQL General Mailing List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] Performance while loading data and indexing |
| Date: | 2002-09-26 21:17:30 |
| Message-ID: | 87n0q4zc0l.fsf@mailbox.samurai.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers pgsql-performance |
Greg Copeland <greg(at)CopelandConsulting(dot)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(at)samurai(dot)com> || PGP Key ID: DB3C29FC
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug McNaught | 2002-09-26 21:31:55 | Re: [HACKERS] Performance while loading data and indexing |
| Previous Message | Greg Copeland | 2002-09-26 21:09:15 | Re: [HACKERS] Performance while loading data and indexing |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-09-26 21:20:52 | Re: Reconstructing FKs in pg_dump |
| Previous Message | Robert Treat | 2002-09-26 21:15:05 | Re: Reconstructing FKs in pg_dump |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug McNaught | 2002-09-26 21:31:55 | Re: [HACKERS] Performance while loading data and indexing |
| Previous Message | Greg Copeland | 2002-09-26 21:09:15 | Re: [HACKERS] Performance while loading data and indexing |