FDW and remote cursor_tuple_fraction

On Sun, Mar 3, 2019 at 12:38 PM auxsvr <auxsvr@gmail.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