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

Re: Bulk loading/merging

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Worky Workerson <worky(dot)workerson(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Bulk loading/merging
Date: 2006-05-31 01:09:22
Message-ID: 20060531010922.GC59464@pervasive.com (view raw or flat)
Thread:
Lists: pgsql-performance
Your best bet is to do this as a single, bulk operation if possible.
That way you can simply do an UPDATE ... WHERE EXISTS followed by an
INSERT ... SELECT ... WHERE NOT EXISTS.

On Fri, May 26, 2006 at 02:48:20PM -0400, Worky Workerson wrote:
> I've set up something similar the 'recommended' way to merge data into
> the DB, i.e.
> 
> http://www.postgresql.org/docs/current/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING
> 
> however I did it with a trigger on insert, i.e. (not my schema :) ):
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby(at)pervasive(dot)com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2006-05-31 03:20:46
Subject: Re: Why the 8.1 plan is worst than 7.4?
Previous:From: Christopher Kings-LynneDate: 2006-05-31 01:07:34
Subject: Re: Query performance

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