Stephen Frost <sfrost(at)snowman(dot)net> writes:
> * Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)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