Re: [HACKERS] Performance while loading data and indexing

From: Mats Lofkvist <mal(at)algonet(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [HACKERS] Performance while loading data and indexing
Date: 2002-09-27 10:40:13
Message-ID: y2q1y7f3ecy.fsf@algonet.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-performance

neilc(at)samurai(dot)com (Neil Conway) writes:

[snip]
> > 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?

UFS on most unix systems (BSD, solaris etc) defaults to sync
metadata, async data which is a mode that is completely missing
from ext2 as far as I know.

This is why UFS is considered safer than ext2. (Running with
'sync' is too slow to be a usable alternative in most cases.)

_
Mats Lofkvist
mal(at)algonet(dot)se

PS The BSD soft updates yields the safety of the default sync
metadata / async data mode while being at least as fast as
running fully async.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mats Lofkvist 2002-09-27 10:49:17 Re: Performance while loading data and indexing
Previous Message Andriy Tkachuk 2002-09-27 10:28:13 Re: query speed depends on lifetime of frozen db?

Browse pgsql-hackers by date

  From Date Subject
Next Message Mats Lofkvist 2002-09-27 10:49:17 Re: Performance while loading data and indexing
Previous Message Andriy Tkachuk 2002-09-27 10:28:13 Re: query speed depends on lifetime of frozen db?

Browse pgsql-performance by date

  From Date Subject
Next Message Mats Lofkvist 2002-09-27 10:49:17 Re: Performance while loading data and indexing
Previous Message Adrian von Bidder 2002-09-27 09:42:22