Stephen Frost <[EMAIL PROTECTED]> writes: > * Tom Lane ([EMAIL PROTECTED]) 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings