Re: [SQL] Slow Inserts Again - Mailing list pgsql-sql

From Frank Morton
Subject Re: [SQL] Slow Inserts Again
Date
Msg-id 06c001be956b$e35db0c0$8355e5ce@base2inc.com
Whole thread Raw
Responses Re: [SQL] Slow Inserts Again
Re: [SQL] Slow Inserts Again
Re: [SQL] Slow Inserts Again
List 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.






pgsql-sql by date:

Previous
From: Vadim Mikheev
Date:
Subject: Re: [SQL] Slow Inserts Again
Next
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [SQL] Slow Inserts Again