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
In response to
pgsql-performance by date
|Next:||From: Craig Ringer||Date: 2010-01-22 03:22:36|
|Subject: Re: Slow update query|
|Previous:||From: Greg Smith||Date: 2010-01-22 00:10:40|
|Subject: Re: TPC-C implementation for postgresql?|