Re: [SQL] Slow Inserts Again

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: Frank Morton <fmorton(at)base2inc(dot)com>
Cc: pgsql-sql(at)hub(dot)org
Subject: Re: [SQL] Slow Inserts Again
Date: 1999-05-03 13:28:59
Message-ID: 372DA49B.C25EDDD6@krs.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Frank Morton wrote:
>
> This last attempt, I bracket each insert statement with
^^^^^^^^^^^^^^^^^^^^^
> "begin;" and "end;".

Why _each_?
Enclose ALL statements by begin; & end; to insert ALL data
in SINGLE transaction:

begin;
insert ....;
insert ....;
...
insert ....;
end;

Vadim

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Herouth Maoz 1999-05-03 13:50:09 Re: [SQL] Slow Inserts Again
Previous Message Joerg Fischer 1999-05-03 13:25:48 No DIVIDE Operator