On Sat, 26 Aug 2000, Jules Bean wrote:
> Is there any simple way for Pg to combine inserts into one bulk?
> Specifically, their effect on the index files. It has always seemed
> to me to be one of the (many) glaring flaws in SQL that the INSERT
> statement only takes one row at a time.
One of MySQL's little syntax abuses allows:
INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..);
which is nice for avoiding database round trips. It's one
of the reasons that mysql can do a bulk import so quickly.
> But, using INSERT ... SELECT, I can imagine that it might be possible
> to do 'bulk' index updating. so that scanning process is done once per
> 'batch'.
Logic for these two cases would be excellent.
Matthew.