Re: [PERFORM] performance problem on big tables

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: [PERFORM] performance problem on big tables
Дата
Msg-id CAMkU=1zsJd4eKhDa0MLzDxUzPnJ=0YaPK01YMx3-izm=gwiJfA@mail.gmail.com
обсуждение исходный текст
Ответ на [PERFORM] performance problem on big tables  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Список pgsql-performance
Дерево обсуждения
On Mon, Aug 14, 2017 at 6:24 AM, Mariel Cherkassky <mariel.cherkassky@gmail.com> wrote:

I have performance issues with two big tables. Those tables are located on an oracle remote database. I'm running the quert : insert into local_postgresql_table select * from oracle_remote_table.

The first table has 45M records and its size is 23G. The import of the data from the oracle remote database is taking 1 hour and 38 minutes.

To investigate this, I'd decouple the two steps and see how long each one takes:

\copy (select * from oracle_remote_table) to /tmp/tmp with binary
\copy local_postresql_table from /tmp/tmp with binary

Cheers,

Jeff

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

Предыдущее
От: Rick Otten
Дата:
Сообщение: Re: [PERFORM] performance problem on big tables
Следующее
От: Jeremy Finzel
Дата:
Сообщение: [PERFORM] Odd sudden performance degradation related to temp object churn