Re: 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: Re: Increase fetch fize of oracl_fdw(ALTER SERVER)
Date: 2022-02-04 03:50:45
Message-ID: CAN0SRDHxLeVZetP_S_9TH5c+xcV2tUw3nxqatYofpbsoNnvJqw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

Hi,
Does anyone have a solution for this?

Regards,
Aditya.

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Midgley 2022-02-04 03:55:56 Re: Increase fetch fize of oracl_fdw(ALTER SERVER)
Previous Message Michael Harris 2022-02-04 01:08:58 Re: Undetected Deadlock

Browse pgsql-sql by date

  From Date Subject
Next Message Steve Midgley 2022-02-04 03:55:56 Re: Increase fetch fize of oracl_fdw(ALTER SERVER)
Previous Message David G. Johnston 2022-02-03 17:04:42 Re: How best to work around the issue - regex string cannot contain brackets