Re: [PERFORM] performance problem on big tables

Поиск
Список
Период
Сортировка
От Mariel Cherkassky
Тема Re: [PERFORM] performance problem on big tables
Дата
Msg-id CA+t6e1kZ4n+USdqmWUG3q4_AcobVQDFJeykzzEDroxXwESH6iA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PERFORM] performance problem on big tables  (Claudio Freire <klaussfreire@gmail.com>)
Список pgsql-performance
Дерево обсуждения
I have the newest version : 
select oracle_diag();
                                                     oracle_diag
---------------------------------------------------------------------------------------------------------------------
 oracle_fdw 1.5.0, PostgreSQL 9.6.3, Oracle client 11.2.0.4.0, ORACLE_HOME=/PostgreSQL/9.6/tools/instantclient_11_2/
(1 row)


Is there a prefetch also for local tables ? I mean If I run with a cursor over results of a select query, mybe setting the prefetch for a local table might also improve performance ?

2017-08-28 8:51 GMT+03:00 Claudio Freire <klaussfreire@gmail.com>:
On Sun, Aug 27, 2017 at 1:34 PM, Mariel Cherkassky
<mariel.cherkassky@gmail.com> wrote:
> Hi, yes indeed I'm using laurenz`s oracle_fdw extension. I tried to run it
> but I'm getting error
>
> dbch=# ALTER FOREIGN TABLE tc_sub_rate_ver_prod OPTIONS ( SET prefetch 10240
> );
> ERROR:  syntax error at or near "10240"
> LINE 1: ...N TABLE tc_sub_rate_ver_prod OPTIONS ( SET prefetch 10240 );
>
>
> dbch=#  alter foreign table tc_sub_rate_ver_prod OPTIONS (SET prefetch
> '10240');
> ERROR:  option "prefetch" not found

Oh, sorry, I hadn't seen this until I hit send.

Unless the documentation is inaccurate or you're using a really old
version (from the changelog that option is from 2016), that should
work.

I don't have enough experience with oracle_fdw to help there, most of
my dealings have been with postgres_fdw.

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

Предыдущее
От: Claudio Freire
Дата:
Сообщение: Re: [PERFORM] performance problem on big tables
Следующее
От: Mariel Cherkassky
Дата:
Сообщение: Re: [PERFORM] printing results of query to file in different times