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 по дате отправления: