Slow COMMIT statements

From: "Felix Feinhals" <ff(at)turtle-entertainment(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Slow COMMIT statements
Date: 2011-12-07 11:31:40
Message-ID: F1CD4AC5B4A5024AAB60E28A82A8450A0488964C@winexch1.office.turtle-entertainment.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2011-12-07 12:45:00 Re: Queries take long long(10 sec.) time running
Previous Message Mamatha_Kagathi_Chan 2011-12-07 10:57:41 Re: [pgadmin-support] Help for Migration