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: (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group