On Thursday, April 07, 2011 1:59:50 pm Szymon Guz wrote: > 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?
Because autocommit wraps each statement in a transaction versus wrapping all the statements in one transaction. Transactions have overhead, the more you have the more time it is going to take. > > regards > Szymon -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
