Re: Foreign data wrappers and indexes on remote side

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Filip Rembiałkowski <filip(dot)rembialkowski(at)gmail(dot)com>
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 16:19:45
Message-ID: 28990.1435335585@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?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 16:21:40 Re: Foreign data wrappers and indexes on remote side
Previous Message Filip Rembiałkowski 2015-06-26 16:09:31 Foreign data wrappers and indexes on remote side