Re: FDW table hints

On Tue, May 03, 2011 at 10:42:30AM +0100, Dave Page wrote:
> On Tue, May 3, 2011 at 10:33 AM, Susanne Ebrecht
> <susanne(at)2ndquadrant(dot)com> wrote:
> > On 03.05.2011 09:30, Magnus Hagander wrote:
> >>
> >> Well, yeah, but I don't think we can squeeze that into 9.1 without
> >> Robert noticing :P
> >>
> >> Any suggestions on *what* the hint should be? Just something along the
> >> line "indexes cannot be created on foreign tables"?
> >
> > Magnus,
> >
> > I am not really sure if this is clever.
> >
> > When we make such a hint for foreign tables then we should make a
> > similar hint for views.
>
> A view really isn't a table, unlike a foreign table, so I don't
> think that argument holds.

There are other systems where it's possible to constrain VIEWs,
something we might approach with an index. One of those systems comes
from some outfit in Redwood Shores, California with cylindrical
buildings, so it's not as wild as it first appears.

Anyhow:

+1 for mentioning that at the moment, it's not possible to create an
index on a foreign table.

+1 also for doing this with VIEWs, but as a separate patch.

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate