Hello
List,
2011-12-07 11:52:52
CET 8075 xxx [local]LOG: duration: 1168.953 ms statement:
COMMIT
2011-12-07 11:52:52 CET 7327 xxx [local]LOG: duration: 1116.119 ms statement: COMMIT
2011-12-07 11:52:52 CET 31727 xxx [local]LOG: duration: 1131.044 ms statement: COMMIT
2011-12-07 11:52:52 CET 25077 xxx [local]LOG: duration: 1064.599 ms statement: COMMIT
2011-12-07 11:52:52 CET 7327 xxx [local]LOG: duration: 1116.119 ms statement: COMMIT
2011-12-07 11:52:52 CET 31727 xxx [local]LOG: duration: 1131.044 ms statement: COMMIT
2011-12-07 11:52:52 CET 25077 xxx [local]LOG: duration: 1064.599 ms statement: COMMIT
these messages show
up in the postgresql logs at irregular intervals. We got no slow queries before
or after these statements. Checkpoint logging is enabled also but these don't
show up either, well they do but minutes later ;).
I would like to
debug these slow COMMITs but don't know what is causing
them.
The server itself is
idling most of the time... with a load avg around 1-2(with 64 cores) and
iowait around 0.5 - 1%.
Notable changes from
default config:
log_min_duration_statement = 500
log_checkpoints =
on
checkpoint_segments
= 40
Regards,
Felix
