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

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

From: Andres Freund <andres(at)anarazel(dot)de>
To: marcin mank <marcin(dot)mank(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, Greg Stark <stark(at)mit(dot)edu>
Subject: Re: [COMMITTERS] pgsql: Speed up CREATE DATABASE by deferring the fsyncs until after
Date: 2010-02-15 10:02:50
Message-ID: 1266228170.2079.2.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
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


In response to

Responses

pgsql-hackers by date

Next:From: Fujii MasaoDate: 2010-02-15 10:18:40
Subject: Re: TCP keepalive support for libpq
Previous:From: Fujii MasaoDate: 2010-02-15 09:40:36
Subject: Re: [BUGS] BUG #4566: pg_stop_backup() reports incorrect STOP WAL LOCATION

pgsql-committers by date

Next:From: Greg StarkDate: 2010-02-15 11:19:24
Subject: Re: [COMMITTERS] pgsql: Speed up CREATE DATABASE by deferring the fsyncs until after
Previous:From: marcin mankDate: 2010-02-15 09:36:40
Subject: Re: [COMMITTERS] pgsql: Speed up CREATE DATABASE by deferring the fsyncs until after

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