Postgres Pro
Downloads
Home   >   mailing lists

postgresql log indicate too many execute S_2:COMMIT - Mailing list pgsql-general

From leo xu
Subject postgresql log indicate too many execute S_2:COMMIT
Date
Msg-id 1335598948905-5672225.post@n5.nabble.com
Whole thread Raw
Responses Re: postgresql log indicate too many execute S_2:COMMIT  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: how to set up automatically startup database when the server boot or reboot.
Next
From: leo xu
Date:
Subject: Re: postgresql standby using pg_archivecleanup don't work