Postgres Pro
Downloads
Home   >   mailing lists

Thread: FDW and remote cursor_tuple_fraction

FDW and remote cursor_tuple_fraction

From
auxsvr
Date:
Hi,

One reason the remote plans via FDW are different than the plans of queries running directly on the remote server is
thata cursor is used, which is optimized for low number of rows according to cursor_tuple_fraction. Is there any way to
setparameters that affect the queries on the remote via FDW? If not, is there any plan to introduce such setting?
 
-- 
Regards,
Peter

Re: FDW and remote cursor_tuple_fraction

From
Jeff Janes
Date:
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