On 10/11/10 22:10, Mark Kirkwood wrote:
What might also be interesting is doing each INSERT with an array-load of bind variables appended to the VALUES clause - as this will only do 1 insert call per "array" of values.
This is probably more like what you were expecting: rows num values tuples(i.e array size) elapsed 1000000 1 106 1000000 10 14 1000000 100 13 1000000 1000 14I didn't try to use PREPARE + EXECUTE here, just did "do" with the INSERT + array size number of VALUES tuples (execute could well be faster). The obvious difference here is we only do rows/(array size) number of insert calls.
Cheers Mark
execinsert-values.pl
Description: Perl program
-- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
