Re: [GENERAL] puzzled by "commit" Logging statement duration

2014-09-02 Thread David G Johnston
Day, David wrote > Hoping for a teachable moment :+) 2-3 of them apparently... > Why is the commit duration so large in [704-1] and the work was done ? in > [703-1] greatly simplified but: COMMIT means - "write to disk"; this is expensive. In a transaction (see below) the statements can b

[GENERAL] puzzled by "commit" Logging statement duration

2014-09-02 Thread Day, David
Hoping for a teachable moment :+) With options enabled to log statement execution times in the postgres log file I observe: 2014-09-02T12:47:38.107808-04:00 alabama local0 info postgres[37874]: [702-1] user=ace_db_client,db=ace_db LOG: duration: 0.040 ms statement: BEGIN 2014-09-02T12:47:38