Stephen Frost <sfrost@snowman.net> writes:
> * Tom Lane (tgl@sss.pgh.pa.us) wrote:
>> You can do any amount of processing you want in an INSERT statement,
>> though.
> Certainly, but for bulk loads that requires more pre-processing work for
> the user and I believe results in more work for the server too (it
> certainly takes longer...).
Have you batched multiple INSERTs into a transaction? Also consider
using a prepared statement to eliminate parse/plan overhead.
regards, tom lane
