Skip site navigation (1) Skip section navigation (2)

Re: Performance on inserts

From: Oliver Teuber <teuber(at)abyss(dot)devicen(dot)de>
To: Matthew Kirkwood <matthew(at)hairy(dot)beasts(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Performance on inserts
Date: 2000-08-26 11:52:01
Message-ID: 20000826135201.A5721@abyss.devicen.de (view raw or flat)
Thread:
Lists: pgsql-hackers
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
 

In response to

Responses

pgsql-hackers by date

Next:From: Kaare RasmussenDate: 2000-08-26 12:53:28
Subject: Re: Proposal for supporting outer joins in 7.1
Previous:From: Alfred PerlsteinDate: 2000-08-26 11:32:51
Subject: Re: Performance on inserts

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group