Quick Links

why autocommit mode is slow?

From:	Szymon Guz <mabewlun(at)gmail(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	why autocommit mode is slow?
Date:	2011-04-07 20:59:50
Message-ID:	BANLkTinvQ4z8pE95e-RVnBXngvORss7zpw@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

Responses

Re: why autocommit mode is slow? at 2011-04-07 21:05:47 from Dann Corbit
Re: why autocommit mode is slow? at 2011-04-07 21:55:17 from Adrian Klaver
Re: why autocommit mode is slow? at 2011-04-08 02:05:13 from Craig Ringer
Re: why autocommit mode is slow? at 2011-04-08 03:06:27 from Scott Marlowe
Re: why autocommit mode is slow? at 2011-04-08 13:00:05 from Vick Khera
Re: why autocommit mode is slow? at 2011-04-08 14:26:57 from Simon Riggs
Re: why autocommit mode is slow? at 2011-04-08 14:56:28 from Andrew Sullivan

Browse pgsql-general by date

	From	Date	Subject
Next Message	Dann Corbit	2011-04-07 21:05:47	Re: why autocommit mode is slow?
Previous Message	Shianmiin	2011-04-07 20:42:12	PostgreSQL backend process high memory usage issue