"Craig A. James" <[EMAIL PROTECTED]> writes:
> If you haven't explored the COPY command yet, check it out.  It is stunningly 
> fast compared to normal INSERT commands.

Note also that his "benchmark" is testing multiple INSERTs issued within
a loop in a plpgsql function, which has got nearly nothing to do with
the performance that will be obtained from INSERTs issued by a client
(especially if said INSERTs aren't prepared and/or aren't batched into
transactions).

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to