On Thu, Apr 7, 2011 at 9:59 PM, Szymon Guz <mabewlun@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
