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
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 |