"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