Increase fetch fize of oracl_fdw(ALTER SERVER)

From: aditya desai <admad123(at)gmail(dot)com>
To: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Increase fetch fize of oracl_fdw(ALTER SERVER)
Date: 2022-02-03 11:40:44
Message-ID: CAN0SRDGKj1mmVgGbSQA1ZQTLgwZxQskfj=MiKKUuxrknHNBjNg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bharath Rupireddy 2022-02-03 12:09:57 Re: max_connections different between primary and standby: is it possible?
Previous Message Matthias Apitz 2022-02-03 10:51:27 Re: sort order for UTF-8 char column with Japanese UTF-8

Browse pgsql-sql by date

  From Date Subject
Next Message Shaozhong SHI 2022-02-03 16:53:18 How best to work around the issue - regex string cannot contain brackets
Previous Message aditya desai 2022-02-03 11:38:17 Re: How can i pass variable in dblink_connect_u ?