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.
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? |
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? |
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 |