Pierre Frédéric Caillaud wrote:
Does postgres write something to the logfile whenever a fsync() takes a suspiciously long amount of time ?
Not specifically. If you're logging statements that take a while, you can see this indirectly, but commits that just take much longer than usual.
If you turn on log_checkpoints, the "sync time" is broken out for you, problems in this area can show up there too.
-- Greg Smith 2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support greg@xxxxxxxxxxxxxxx www.2ndQuadrant.com -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
