|
It has nothing to do with autocommit and everything to do with batching them together. For instance, if you run ten update queries in autocommit mode I would expect it to take exactly the same time as:
Exec Query1 Commit â Begin Exec Query10 Commit From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx]
On Behalf Of Szymon Guz Hi, this is maybe a stupid question, but I don't know how to explain to my coworkers why performing many inserts in autocommit mode is so much slower than making all of them in one transaction. Why is that so slow? regards Szymon |
