Re: Increase fetch fize of oracl_fdw(ALTER SERVER)

[David G. Johnston]

On Thu, Feb 3, 2022 at 9:03 PM aditya desai <admad...@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.