Forum OpenACS Q&A: Response to outer joins, views, and indexes in PG

Collapse
Posted by Jonathan Ellis on
aha...

the second problem resulted from this view being joined with another (minion_spells_denorm_v) that also used minions as a base table.  Apparently that confused the planner into thinking it needed to do the cross join.