Search Postgresql Archives

Re: Foreign data wrappers and indexes on remote side

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Is WHERE clause push-down implemented in any known fdw?

Thank you.



On Fri, Jun 26, 2015 at 6:19 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
> =?UTF-8?Q?Filip_Rembia=C5=82kowski?= <filip.rembialkowski@xxxxxxxxx> 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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux