Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group