Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Bulk loading/merging
- From: "Jim C. 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: Tue, 30 May 2006 20:09:22 -0500
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
- References:
- Bulk loading/merging
- From: Worky Workerson
- Bulk loading/merging
- Prev by Date: Re: Why the 8.1 plan is worst than 7.4?
- Next by Date: Re: Query performance
- Previous by thread: Re: Bulk loading/merging
- Next by thread: App very unresponsive while performing simple update
- Indexes: