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