Sam Mason <sam@xxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
