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@2ndQuadrant.com www.2ndQuadrant.com