Re: [SQL] Slow Inserts Again

From: "Frank Morton" <fmorton(at)base2inc(dot)com>
To: "Vadim Mikheev" <vadim(at)krs(dot)ru>
Cc: <pgsql-sql(at)hub(dot)org>
Subject: Re: [SQL] Slow Inserts Again
Date: 1999-05-03 13:50:21
Message-ID: 06c001be956b$e35db0c0$8355e5ce@base2inc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>> 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:

This was suggested by someone on the list so that all
150,000 inserts would not be treated as one large transaction.

Like I said before, I have tried all suggestions without success.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jan Wieck 1999-05-03 13:52:11 Re: [SQL] Slow Inserts Again
Previous Message Herouth Maoz 1999-05-03 13:50:09 Re: [SQL] Slow Inserts Again