Josh Berkus <josh@xxxxxxxxxxxx> writes: >> > I actually think the way to attack this issue is to discuss the kinds >> > of errors the planner makes, and what tweaks we could do to correct >> > them. Here's the ones I'm aware of: >> > >> > -- Incorrect selectivity of WHERE clause >> > -- Incorrect selectivity of JOIN >> > -- Wrong estimate of rows returned from SRF >> > -- Incorrect cost estimate for index use >> > >> > Can you think of any others? -- Incorrect estimate for result of DISTINCT or GROUP BY. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com
