Horton
Menu

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

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Greg Stark <stark@mit.edu>
Cc: pgsql-hackers@postgresql.org
Date: 2010-02-15T06:57:19Z
Lists: pgsql-hackers 
stark@postgresql.org (Greg Stark) writes:
> Log Message:
> -----------
> Speed up CREATE DATABASE by deferring the fsyncs until after copying
> all the data and using posix_fadvise to nudge the OS into flushing it
> earlier. This also hopefully makes CREATE DATABASE avoid spamming the
> cache.

The buildfarm indicates that this patch has got some serious issues.

			regards, tom lane