On Thu, Aug 23, 2018 at 5:20 PM, Peter Geoghegan <p...@bowt.ie> wrote: > This patch adds an enhancement that is an example of a broader class > of optimizer enhancement primarily aimed at making star-schema queries > have more efficient plans, by arranging to use several independent > nested loop joins based on a common pattern. Each nestloop join has > one particular dimension table on the outer side, and the fact table > on the inner side.
Correction: I meant that for each join, the outer side is a scan of some particular fact table index, while the inner side probes some particular dimension table's primary key, and evaluates the dimension's qual. -- Peter Geoghegan