Postgres Pro
Downloads
Home   >   mailing lists

Foreign data wrappers and indexes on remote side - Mailing list pgsql-general

From Filip Rembiałkowski
Subject Foreign data wrappers and indexes on remote side
Date
Msg-id CAP_rww=AsWwLz2hbKVA=Nf=0thP4c+=c5BQM2T-toxPFOz+7MA@mail.gmail.com
Whole thread Raw
Responses Re: Foreign data wrappers and indexes on remote side
Re: Foreign data wrappers and indexes on remote side
List pgsql-general
Tree view 
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 by date:

Previous
From: Tim Smith
Date:
Subject: Re: Functions, savepoints, autocommit = I am confused !
Next
From: Tom Lane
Date:
Subject: Re: Foreign data wrappers and indexes on remote side