Re: [PERFORM] index scan through a subquery

2007-02-06 Thread Bill Howe
Tom Lane wrote: >> I need the lovely index scan, but my table is hidden behind a view, and >> all I get is the ugly sequential scan. Any ideas on how to convince the >> optimizer to unfold the subquery properly? > > You should provide some context in this sort of gripe, like which PG > version yo

Re: [PERFORM] index scan through a subquery

2007-02-05 Thread Tom Lane
Bill Howe <[EMAIL PROTECTED]> writes: > I need the lovely index scan, but my table is hidden behind a view, and > all I get is the ugly sequential scan. Any ideas on how to convince the > optimizer to unfold the subquery properly? You should provide some context in this sort of gripe, like which