Re: bulk inserts

Sam Mason <sam@samason.me.uk> writes:
> On Tue, Sep 29, 2009 at 08:45:55AM -0700, Alan Hodgson wrote:
>> I think a big reason is also that the client can stream the data without
>> waiting for a network round trip ack on every statement.

> I don't think so.  I'm pretty sure you can send multiple statements in a
> single round trip.

You can, but that doesn't scale to megabytes of data (at least not
well).

I think the big points are elimination of per-row network and
transaction commit overhead ... but there are some other optimizations
in the COPY path too.

            regards, tom lane