From: | Steve Midgley <science(at)misuse(dot)org> |
---|---|
To: | aditya desai <admad123(at)gmail(dot)com> |
Cc: | pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Increase fetch fize of oracl_fdw(ALTER SERVER) |
Date: | 2022-02-04 03:55:56 |
Message-ID: | CAJexoSJaKEjkF=gNkcDWo9XMLu60iBuo384nL4=ZqKxhpVKRoA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
On Thu, Feb 3, 2022 at 7:51 PM aditya desai <admad123(at)gmail(dot)com> wrote:
> Hi,
> Does anyone have a solution for this?
>
> Regards,
> Aditya.
>
> On Thu, Feb 3, 2022 at 5:10 PM aditya desai <admad123(at)gmail(dot)com> wrote:
>
>> Hi,
>> For Postgres_Fdw we have below command to increase the fetch size.
>>
>> ALTER SERVER ServerName OPTIONS ( fetch_size='50000');
>>
>> Do we have a similar command for oracle_fdw?
>>
>>
I wasn't familiar with oracle_fdw - I searched and found this project:
https://github.com/laurenz/oracle_fdw
Is this the tool you are using? This doesn't look like a sql related
postgres language question to me. I'd suggest you contact the author of the
project and get support for config settings from them. I just don't want
you waiting for answers from this list, when possibly no one on this list
uses this tool (I have no idea if anyone does or doesn't). Superior
knowledge always welcome!
Steve
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2022-02-04 03:56:44 | Re: Increase fetch fize of oracl_fdw(ALTER SERVER) |
Previous Message | aditya desai | 2022-02-04 03:50:45 | Re: Increase fetch fize of oracl_fdw(ALTER SERVER) |
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2022-02-04 03:56:44 | Re: Increase fetch fize of oracl_fdw(ALTER SERVER) |
Previous Message | aditya desai | 2022-02-04 03:50:45 | Re: Increase fetch fize of oracl_fdw(ALTER SERVER) |