Re: [PERFORM] performance problem on big tables

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: [PERFORM] performance problem on big tables
Дата
Msg-id CAMkU=1zh2iGYVriwcMOXS8GB7BKB-k6Am1xK6H1LUh_-RwLjqQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PERFORM] performance problem on big tables  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Ответы Re: [PERFORM] performance problem on big tables
Список pgsql-performance
Дерево обсуждения
On Tue, Aug 15, 2017 at 3:06 AM, Mariel Cherkassky <mariel.cherkassky@gmail.com> wrote:
Hi,
So I I run the cheks that jeff mentioned :  
\copy (select * from oracle_remote_table) to /tmp/tmp with binary - 1 hour and 35 minutes
\copy local_postresql_table from /tmp/tmp with binary - Didnt run because the remote oracle database is currently under maintenance work.

The "\copy...from" doesn't depend on oracle, it would be only depend on local file system (/tmp/tmp), provided that the "\copy...to" finished.  Anyway, given the length of time it took, I think you can conclude the bottleneck is in oracle_fdw itself, or in Oracle, or the network.

Cheers,

Jeff

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

Предыдущее
От: Jeremy Finzel
Дата:
Сообщение: Re: [PERFORM] Odd sudden performance degradation related to tempobject churn
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: [PERFORM] Odd sudden performance degradation related to tempobject churn