Increase fetch fize of oracl_fdw(ALTER SERVER)

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:

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

On Thu, Feb 3, 2022 at 8:51 PM aditya desai <admad123@gmail.com> wrote:

Hi,
Does anyone have a solution for this?

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?

The oracle_fdw project isn't even handled in the core PostgreSQL project so
none of our lists are really a good location to post this question. But if
you do want to have a chance at a response you should post to the -general
list where people actually discuss topics of general interest to the
community, not the SQL list which is basically a list for beginners who are
trying to learn SQL.

David J.

Ok. Let me try in another list.

On Fri, Feb 4, 2022 at 9:27 AM David G. Johnston <david.g.johnston@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?

Thanks in advance.

Regards,
Aditya.

On Thu, Feb 3, 2022 at 9:03 PM aditya desai <admad123@gmail.com> wrote:

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?

The SQL command itself is generic. The option name that seems to be
similar is called "prefetch". It is documented in the project's README.md
file.

David J.

Thanks Setve! This helped.

On Fri, Feb 4, 2022 at 9:26 AM Steve Midgley <science@misuse.org> wrote:

Thanks David.

On Fri, Feb 4, 2022 at 9:44 AM David G. Johnston <david.g.johnston@gmail.com>
wrote: