On Thu, Apr 7, 2011 at 9:59 PM, Szymon Guz <mabewlun@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