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

From Filip Rembiałkowski
Subject Re: Foreign data wrappers and indexes on remote side
Date
Msg-id CAP_rww=LYHLkner+MqTG-vbgxr33H=+m9z9wdW=me_Zh1-hn1g@mail.gmail.com
Whole thread Raw
In response to Re: Foreign data wrappers and indexes on remote side  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Foreign data wrappers and indexes on remote side  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Is WHERE clause push-down implemented in any known fdw?

Thank you.



On Fri, Jun 26, 2015 at 6:19 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> =?UTF-8?Q?Filip_Rembia=C5=82kowski?= <filip.rembialkowski@gmail.com> writes:
>> 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 would be something to discuss with the author of tds_fdw.  It's
> mostly on the head of each individual FDW how smart plans for it will be.
>
>                         regards, tom lane


pgsql-general by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Question about the isolation level and visible
Next
From: "David G. Johnston"
Date:
Subject: Re: Foreign data wrappers and indexes on remote side