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 15:45:55
Message-ID: 200909290845.55984@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'm not sure what you're implying about the semantics here, but it
> doesn't seem right.  COPY doesn't somehow break out of ACID semantics,
> it's only an *optimization* that allows you to get large quantities of
> data into the database faster.  The main reason 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.


-- 
"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: Sam MasonDate: 2009-09-29 16:01:59
Subject: Re: computed values in plpgsql
Previous:From: Pavel StehuleDate: 2009-09-29 15:42:37
Subject: Re: computed values in plpgsql

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