Re: Foreign data wrappers and indexes on remote side

From: Filip Rembiałkowski <filip(dot)rembialkowski(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Foreign data wrappers and indexes on remote side
Date: 2015-06-26 19:31:21
Message-ID: CAP_rww=LYHLkner+MqTG-vbgxr33H=+m9z9wdW=me_Zh1-hn1g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> =?UTF-8?Q?Filip_Rembia=C5=82kowski?= <filip(dot)rembialkowski(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2015-06-26 19:45:02 Re: Foreign data wrappers and indexes on remote side
Previous Message Kevin Grittner 2015-06-26 19:26:35 Re: Question about the isolation level and visible