Re: Re: Faster CREATE DATABASE by delaying fsync - Mailing list pgsql-hackers

From Florian Weimer
Subject Re: Re: Faster CREATE DATABASE by delaying fsync
Date
Msg-id 87wryfpnuv.fsf@mid.deneb.enyo.de
Whole thread Raw
In response to Re: Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Re: Faster CREATE DATABASE by delaying fsync  (Mark Mielke <mark@mark.mielke.cc>)
List pgsql-hackers
* Tom Lane:

>> Which options would that be? I am not aware that there any for any of the 
>> recent linux filesystems.
>
> Shouldn't journaling of metadata be sufficient?

You also need to enforce ordering between the directory update and the
file update.  The file metadata is flushed with fsync(), but the
directory isn't.  On some systems, all directory operations are
synchronous, but not on Linux.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: LISTEN/NOTIFY versus encoding conversion
Next
From: Mark Mielke
Date:
Subject: Re: Re: Faster CREATE DATABASE by delaying fsync