Re: bulk inserts

On Tue, Sep 29, 2009 at 08:45:55AM -0700, Alan Hodgson wrote:
> On Tuesday 29 September 2009, Sam Mason <sam@samason.me.uk> wrote:
> > it's faster is because
> > parsing CSV data is easier than parsing SQL.
> >
> > At least I think that's the only difference; anybody know better?
>
> 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.  libpq is defined to work in such cases anyway:

  http://www.postgresql.org/docs/current/static/libpq-exec.html

--
  Sam  http://samason.me.uk/