Re: [COMMITTERS] Re: pgsql: Speed up CREATE DATABASE by deferring the fsyncs until after

From: Andres Freund <andres(at)anarazel(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Greg Stark <stark(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [COMMITTERS] Re: pgsql: Speed up CREATE DATABASE by deferring the fsyncs until after
Date: 2010-02-23 07:43:21
Message-ID: 201002230843.32394.andres@anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Hi Tom,

On Tuesday 23 February 2010 06:37:26 Tom Lane wrote:
> I wrote:
> > Any theories about what is happening?
> Now, this doesn't mean that all is fine and dandy. I believe that a
> majority of Unixen will reject attempts to open directories for writing,
> so this solution puts us even further away from being able to fsync the
> directories. I would bet however that the platforms that reject this
> are ones that don't need fsync on directories. Maybe we just have to
> have two different code paths depending on platform :-(
Cool.
You can't open a directory for writing under linux as well though - so that
wont be the decisive argument. Do you have a better idea than a configure
test?

Andres

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Greg Stark 2010-02-23 09:12:02 Re: [COMMITTERS] Re: pgsql: Speed up CREATE DATABASE by deferring the fsyncs until after
Previous Message Bruce Momjian 2010-02-23 06:29:01 pgsql: Secondary patch to fix interval to_char() for "HH" where hours >=

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2010-02-23 08:26:19 Re: Issues for named/mixed function notation patch
Previous Message Heikki Linnakangas 2010-02-23 07:08:44 Re: Streaming replication and pg_xlogfile_name()