Re: Re: Faster CREATE DATABASE by delaying fsync

From: Florian Weimer <fw(at)deneb(dot)enyo(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Greg Stark <gsstark(at)mit(dot)edu>, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Re: Faster CREATE DATABASE by delaying fsync
Date: 2010-02-14 20:24:24
Message-ID: 87wryfpnuv.fsf@mid.deneb.enyo.de
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-hackerspgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Mielke 2010-02-14 20:41:02 Re: Re: Faster CREATE DATABASE by delaying fsync
Previous Message Boszormenyi Zoltan 2010-02-14 19:05:30 Re: PostgreSQL on SMP Architectures

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Mielke 2010-02-14 20:41:02 Re: Re: Faster CREATE DATABASE by delaying fsync
Previous Message Tom Lane 2010-02-14 20:15:30 LISTEN/NOTIFY versus encoding conversion