projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: e26c539) | patch
Speed up CREATE DATABASE by deferring the fsyncs until after copying
authorGreg Stark <stark@mit.edu>
Mon, 15 Feb 2010 00:50:57 +0000 (00:50 +0000)
committerGreg Stark <stark@mit.edu>
Mon, 15 Feb 2010 00:50:57 +0000 (00:50 +0000)
commitf8c183a1ac02aef14832c1f29946ef2bcb5866b7
treefcbeac8862b585b58786fead156a43022d015224tree
parente26c539e9f326ea843c0ed005af093b56b55cd4dcommit | diff
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.

Tests show a big speedup on Linux at least on some filesystems.

Idea and patch from Andres Freund.
src/backend/storage/file/fd.c diff | blob | blame | history
src/include/storage/fd.h diff | blob | blame | history
src/port/copydir.c diff | blob | blame | history
This is the main PostgreSQL git repository.