Sam Mason <sam(at)samason(dot)me(dot)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