| From: | leo xu <leoxu8703(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | postgresql log indicate too many execute S_2:COMMIT |
| Date: | 2012-04-28 07:42:28 |
| Message-ID: | 1335598948905-5672225.post@n5.nabble.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello:
I test postgresql database performance recently,i set
log_min_duration_statement=1000;
i monitor pg_log file,i find too many execue S_2:commit
10.0.44.21:30170:2012-04-28 11:38:46.340 CSTLOG: duration: 1050.679 ms
execute S_2: COMMIT
10.0.44.21:30208:2012-04-28 11:38:46.340 CSTLOG: duration: 1050.576 ms
execute S_2: COMMIT
10.0.44.21:30318:2012-04-28 11:38:46.340 CSTLOG: duration: 1028.171 ms
execute S_2: COMMIT
........
please explain what meaning,how to cause it ,how to deal with it?thank you !
--
View this message in context: http://postgresql.1045698.n5.nabble.com/postgresql-log-indicate-too-many-execute-S-2-COMMIT-tp5672225p5672225.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jasen Betts | 2012-04-28 08:47:50 | Re: how to set up automatically startup database when the server boot or reboot. |
| Previous Message | leo xu | 2012-04-28 07:16:14 | Re: postgresql standby using pg_archivecleanup don't work |