On Tue, 2012-03-13 at 09:42 +0100, Andres Freund wrote: > for recursively everything in dir: > posix_fadvise(fd, POSIX_FADV_DONTNEED); > > for recursively everything in dir: > fsync(fd);
Wow, that made a huge difference!
no sync: ~ 1.0s
sync: ~10.0s
fadvise+sync: ~ 1.3s
Patch attached.
Now I feel much better about it. Most people will either have fadvise, a
write cache (rightly or wrongly), or actually need the sync. Those that
have none of those can use -N.
Regards,
Jeff Davis
initdb-fsync-20120313.patch.gz
Description: GNU Zip compressed data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
