Postgres Pro
Downloads
Home   >   mailing lists

Re: Increase fetch fize of oracl_fdw(ALTER SERVER) - Mailing list pgsql-sql

From Steve Midgley
Subject Re: Increase fetch fize of oracl_fdw(ALTER SERVER)
Date
Msg-id CAJexoSJaKEjkF=gNkcDWo9XMLu60iBuo384nL4=ZqKxhpVKRoA@mail.gmail.com
Whole thread Raw
In response to Re: Increase fetch fize of oracl_fdw(ALTER SERVER)  (aditya desai <admad123@gmail.com>)
Responses Re: Increase fetch fize of oracl_fdw(ALTER SERVER)  (aditya desai <admad123@gmail.com>)
List pgsql-sql
Tree view

On Thu, Feb 3, 2022 at 7:51 PM aditya desai <admad123@gmail.com> wrote:
Hi,
Does anyone have a solution for this?

Regards,
Aditya.

On Thu, Feb 3, 2022 at 5:10 PM aditya desai <admad123@gmail.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
 

pgsql-sql by date:

Previous
From: aditya desai
Date:
Subject: Re: Increase fetch fize of oracl_fdw(ALTER SERVER)
Next
From: "David G. Johnston"
Date:
Subject: Re: Increase fetch fize of oracl_fdw(ALTER SERVER)