Re: FDW and remote cursor_tuple_fraction

2019-03-03 Thread Jeff Janes
On Sun, Mar 3, 2019 at 12:38 PM auxsvr 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

FDW and remote cursor_tuple_fraction

2019-03-03 Thread auxsvr
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