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

Hi Marcin,

Sounds rather unlikely to me. Its likely handled at an upper layer (vfs in linux' case) and only overloaded when an optimized implementation is available.
Which os do you see implementing that only on a part of the filesystems?

A runtime check would be creating, fsyncing and deleting a directory for every directory youre fsyncing because they could be on a different fs...

Andres
--
Sent from a mobile phone - please excuse brevity and formatting.
----- Ursprüngliche Mitteilung -----
> On Mon, Feb 15, 2010 at 9:36 AM, Andres Freund <andres(at)anarazel(dot)de> wrote:
> > On Monday 15 February 2010 08:13:32 Tom Lane wrote:
> > > Actually, looking closer, some of the Windows machines started failing
> > > after the *earlier* patch to add directory fsyncs.
> > And not only the windows machines. Seems sensible to add a configure check
> > whether directory-fsyncing works.
>
> It looks like a thing that can be filesystem-dependent. Maybe a kind
> of runtime check?
>
> Greetings
> Marcin Mańk
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers