Обсуждение: FDW and remote cursor_tuple_fraction

Поиск
Список
Период
Сортировка

FDW and remote cursor_tuple_fraction

От
auxsvr
Дата:
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

От
Jeff Janes
Дата:
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