Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: [COMMITTERS] pgsql: Speed up CREATE DATABASE by deferring the fsyncs until after
Date
Msg-id 10713.1266217039@sss.pgh.pa.us
Whole thread Raw
Responses Re: [COMMITTERS] pgsql: Speed up CREATE DATABASE by deferring the fsyncs until after
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Parameter name standby_mode
Next
From: Tom Lane
Date:
Subject: Re: [COMMITTERS] pgsql: Speed up CREATE DATABASE by deferring the fsyncs until after