On Sun, Mar 3, 2019 at 12:38 PM auxsvr <auxsvr(at)gmail(dot)com> wrote:
> Hi,
>
> One reason the remote plans via FDW are different than the plans of
> queries running directly on the remote server is that a cursor is used,
> which is optimized for low number of rows according to
> cursor_tuple_fraction. Is there any way to set parameters that affect the
> queries on the remote via FDW? If not, is there any plan to introduce such
> setting?
>
It is a bit ugly, but there is this:
alter server foo options (options '-c cursor_tuple_fraction=1.0');
Cheers,
Jeff