Re: Best COPY Performance

Поиск
Список
Период
Сортировка
От Spiegelberg, Greg
Тема Re: Best COPY Performance
Дата
Msg-id 82E74D266CB9B44390D3CCE44A781ED9016E003F@POSTOFFICE.cranel.local
обсуждение исходный текст
Ответ на Best COPY Performance  ("Worky Workerson" <worky.workerson@gmail.com>)
Ответы Re: Best COPY Performance  ("Craig A. James" <cjames@modgraph-usa.com>)
Список pgsql-performance
> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org
> [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of
> Craig A. James
> Sent: Wednesday, October 25, 2006 12:52 PM
> To: Jim C. Nasby
> Cc: Worky Workerson; Merlin Moncure; pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] Best COPY Performance
>
> Jim C. Nasby wrote:
> > Wait... so you're using perl to copy data between two tables? And
> > using a cursor to boot? I can't think of any way that could be more
> > inefficient...
> >
> > What's wrong with a plain old INSERT INTO ... SELECT? Or if
> you really
> > need to break it into multiple transaction blocks, at least don't
> > shuffle the data from the database into perl and then back into the
> > database; do an INSERT INTO ... SELECT with that same where clause.
>
> The data are on two different computers, and I do processing
> of the data as it passes through the application.  Otherwise,
> the INSERT INTO ... SELECT is my first choice.

Would dblink() help in any way?

Greg



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

Предыдущее
От: "Craig A. James"
Дата:
Сообщение: Re: Best COPY Performance
Следующее
От: "Craig A. James"
Дата:
Сообщение: Re: Best COPY Performance