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