Re: Performace Optimization for Dummies

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: Performace Optimization for Dummies
Дата
Msg-id 20060928184538.GV34238@nasby.net
обсуждение исходный текст
Ответ на Re: Performace Optimization for Dummies  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
Список 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@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Performace Optimization for Dummies
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: ...