Обсуждение: Slow COMMIT statements

Поиск
Список
Период
Сортировка

Slow COMMIT statements

От
"Felix Feinhals"
Дата:
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
 
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