On Thu, Apr 7, 2011 at 9:59 PM, Szymon Guz <mabew...@gmail.com> wrote:

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

There's a performance bug that slows things down more than necessary.

I've worked out a solution that we can use to improve that.

Not sure that we should backpatch it though.

-- 
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to