Re: [SQL] Slow Inserts Again - Mailing list 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