On 8 April 2011 05:06, Scott Marlowe scott.marl...@gmail.com wrote:
On Thu, Apr 7, 2011 at 2:59 PM, Szymon Guz mabew...@gmail.com 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
On Thu, Apr 7, 2011 at 4: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.
as others have said, there is
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
On Thu, Apr 07, 2011 at 10:59:50PM +0200, 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?
If you do
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
...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Szymon Guz
Sent: Thursday, April 07, 2011 2:00 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] why autocommit mode is slow?
Hi,
this is maybe a stupid question, but I don't know how to explain to my
coworkers why performing many
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
On 04/08/2011 04:59 AM, 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?
Unless you have synchronous_commit
On Thu, Apr 7, 2011 at 2:59 PM, Szymon Guz mabew...@gmail.com 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?
The real