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

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.
> 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    work: 512-231-6117
vcard:       cell: 512-569-9461

In response to


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