Thread: Fwd: Increase fetch fize of oracl_fdw(ALTER SERVER)
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 David.
On Fri, Feb 4, 2022 at 9:44 AM David G. Johnston <david.g.johnston@gmail.com> wrote:
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.