On Thu, Feb 16, 2012 at 19:18, Dan Scales <sca...@vmware.com> wrote: > fsync/fdatasync can be very slow on ext3, because it seems to have to > always wait for the current filesystem meta-data transaction to complete, > even if that meta-data operation is completely unrelated to the file > being fsync'ed.
Use the data=writeback mount option to remove this restriction. This is actually the suggested setting for PostgreSQL file systems: http://www.postgresql.org/docs/current/static/wal-intro.html (Note that this is unsafe for some other applications, so I wouldn't use it on the root file system) Regards, Marti -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
