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