Re: Performance on inserts

On Sat, Aug 26, 2000 at 12:14:06PM +0100, Matthew Kirkwood wrote:
> 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.
>
copy seems to be very fast ... i dont know why all people use
multiple inserts ??? just use copy ...

yours, oliver teuber