Re: Foreign data wrappers and indexes on remote side

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Foreign data wrappers and indexes on remote side
Дата
Msg-id CAKFQuwZyvjYciSaKS3of3hg4nuPP7mRos4p3f+JOkAXHnsAHiQ@mail.gmail.com
обсуждение исходный текст
Ответ на Foreign data wrappers and indexes on remote side  (Filip Rembiałkowski <filip.rembialkowski@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Fri, Jun 26, 2015 at 12:09 PM, Filip Rembiałkowski <filip.rembialkowski@gmail.com> wrote:
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;

​It is possible but implementation is the responsibility of the FDW middleware authors.

Since "tds_fdw" is not core this would not be the correct forum.

David J.
​
 

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

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