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');