On Wed, Apr 8, 2009 at 11:59 AM, Tom Lane <[email protected]> wrote: > Robert Haas <[email protected]> writes: >> On Wed, Apr 8, 2009 at 10:33 AM, Tom Lane <[email protected]> wrote: >>> The main point is that the planner will prefer a bitmap scan for any >>> query that's estimated to return more than quite a small number of rows. > >> That makes sense, but what about the nestloop-over-inner-indexscan case? > > What about it? The provided patch made no attempt to optimize that > case. > > Doing so might well be interesting, but it's not getting done for 8.4. > I think it would be quite an invasive patch --- it's hard to see how to > do it without explicit support at the nestloop join level, so that you > could pipeline the processing of multiple key values coming from the outer > side of the join.
OK, I think I'm now understanding your line of thinking. Thanks for the explanation. ...Robert -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
