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

Re: Performace Optimization for Dummies

From: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
To: Carlo Stonebanks <stonec(dot)register(at)sympatico(dot)ca>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performace Optimization for Dummies
Date: 2006-09-28 18:45:38
Message-ID: 20060928184538.GV34238@nasby.net (view raw or flat)
Thread:
Lists: pgsql-performance
On Thu, Sep 28, 2006 at 01:53:22PM -0400, Carlo Stonebanks wrote:
> > are you using the 'copy' interface?
> 
> Straightforward inserts - the import data has to transformed, normalised and 
> de-duped by the import program. I imagine the copy interface is for more 
> straightforward data importing. These are - buy necessity - single row 
> inserts.

BTW, stuff like de-duping is something you really want the database -
not an external program - to be doing. Think about loading the data into
a temporary table and then working on it from there.
-- 
Jim Nasby                                            jim(at)nasby(dot)net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

In response to

Responses

pgsql-performance by date

Next:From: Matthew NuzumDate: 2006-09-28 18:47:26
Subject: Re: Performace Optimization for Dummies
Previous:From: Jim C. NasbyDate: 2006-09-28 18:44:13
Subject: Re: Performace Optimization for Dummies

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