Foreign data wrappers and indexes on remote side

Поиск
Список
Период
Сортировка
От Filip Rembiałkowski
Тема Foreign data wrappers and indexes on remote side
Дата
Msg-id CAP_rww=AsWwLz2hbKVA=Nf=0thP4c+=c5BQM2T-toxPFOz+7MA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Foreign data wrappers and indexes on remote side  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Foreign data wrappers and indexes on remote side  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Hi.

Is there any way to take use of indexes on foreign tables?

Currently (at least with tds_fdw, that I was testing) the planner just
does a dumb full sequential scan in all cases.

That is

SELECT drink FROM foreignbar;

-- takes as much time as

SELECT drink FROM foreignbar where drink_key = 3210;


Thanks!


В списке pgsql-general по дате отправления:

Предыдущее
От: Tim Smith
Дата:
Сообщение: Re: Functions, savepoints, autocommit = I am confused !
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Foreign data wrappers and indexes on remote side