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

Re: bulk inserts

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: bulk inserts
Date: 2009-09-29 16:11:19
Message-ID: 200909290911.19709@hal.medialogik.com (view raw or flat)
Thread:
Lists: pgsql-general
On Tuesday 29 September 2009, Sam Mason <sam(at)samason(dot)me(dot)uk> 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.  libpq is defined to work in such cases anyway:
>
>   http://www.postgresql.org/docs/current/static/libpq-exec.html
>

I'm sure you probably _can_, but how many programming loops do so?


-- 
"No animals were harmed in the recording of this episode. We tried but that 
damn monkey was just too fast."

In response to

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2009-09-29 16:17:51
Subject: Re: bulk inserts
Previous:From: Sam MasonDate: 2009-09-29 16:04:37
Subject: Re: bulk inserts

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