Re: [GENERAL] postgresql log indicate too many execute S_2:COMMIT

2012-05-02 Thread leo xu
my postgres version is 9.1.2.my machine is dell R710.3000 sessions connect to database concurrently,then doing some insert,delete,update. your meaning my database bottleneck is disk io slowly.i use local disk.i know transaction log need to wirte to disk. thanks.i will monitor it. -

Re: [GENERAL] postgresql log indicate too many execute S_2:COMMIT

2012-04-30 Thread Albe Laurenz
leo xu wrote: > 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:

[GENERAL] postgresql log indicate too many execute S_2:COMMIT

2012-04-28 Thread leo xu
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: d