Re: [COMMITTERS] pgsql: Speed up CREATE DATABASE by deferring the fsyncs until after
Greg Stark <stark@mit.edu>
From: Greg Stark <stark@mit.edu>
To: Andres Freund <andres@anarazel.de>
Cc: marcin mank <marcin.mank@gmail.com>, pgsql-hackers@postgresql.org
Date: 2010-02-15T11:19:24Z
Lists: pgsql-hackers
On Mon, Feb 15, 2010 at 10:02 AM, Andres Freund <andres@anarazel.de> wrote: > 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... We could just not check the result code of the fsync. Or print a warning the first time and stop trying subsequently. When do we cut the alpha? If I look at it at about 10-11pm EST is that too late? -- greg