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,
ORA
On Sun, Aug 27, 2017 at 1:34 PM, Mariel Cherkassky
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: .
On Sun, Aug 27, 2017 at 1:34 PM, Mariel Cherkassky
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: .
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=#
> On Aug 25, 2017, at 17:07, Tom Lane wrote:
>
> =?utf-8?Q?Felix_Geisend=C3=B6rfer?= writes:
>> I recently came across a performance difference between two machines that
>> surprised me:
>> ...
>> As you can see, Machine A spends 5889ms on the Sort Node vs 609ms on Machine
>> B when looking a
