Re: [COMMITTERS] Re: pgsql: Speed up CREATE DATABASE by deferring the fsyncs until after
Andres Freund <andres@anarazel.de>
From: Andres Freund <andres@anarazel.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Greg Stark <stark@postgresql.org>,
pgsql-hackers@postgresql.org
Date: 2010-02-23T07:43:21Z
Lists: 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