"Craig Ringer" <craig@xxxxxxxxxxxxxxxxxxxxx> writes: > It strikes me that there are really two types of query hint possible here. > > One tells the planner (eg) "prefer a merge join here". > > The other gives the planner more information that it might not otherwise > have to work with, so it can improve its decisions. "The values used in > this join condition are highly correlated". This sounds familiar: http://article.gmane.org/gmane.comp.db.postgresql.devel.general/55730/match=hints Plus ça change... -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning
