Horton

Re: [HACKERS] Performance while loading data and indexing

Curt Sampson <cjs@cynic.net>

View thread View on postgr.es
From: Curt Sampson <cjs@cynic.net>
To: Neil Conway <neilc@samurai.com>
Cc: PostgresSQL Hackers Mailing List <pgsql-hackers@postgresql.org>, PostgresSQL General Mailing List <pgsql-general@postgresql.org>
Date: 2002-10-06T15:52:24Z
Lists: pgsql-hackers, pgsql-performance, pgsql-general 
On 26 Sep 2002, Neil Conway wrote:

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

It was sort of pointed out here, but perhaps not made completely
clear, that Berkley FFS defaults to synchronous meta-data updates,
but asynchronous data updates. You can also specify entirely
synchronous or entirely asynchronous updates. Linux ext2fs supports
only these last two modes, which is the problem.

cjs
-- 
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC