>>>>> "Neil" == Neil Conway <[EMAIL PROTECTED]> writes:
Neil> It occurred to me that these kinds of poor planning
Neil> decisions could easily be detected by PostgreSQL itself:
Neil> after we've finished executing a plan, we can trivially
Neil> compare the # of results produced by each node in the query
Neil> tree with the # of results the planner expected that node to
Neil> produce (look at EXPLAIN ANALYZE, for example). If the
Indeed. This is the approach being followed by the LeO project
(Learning Optimizer) at IBM Almaden.
http://www.almaden.ibm.com/software/dm/SMART/leo.shtml
There is a vldb paper that describes it ..
--
Pip-pip
Sailesh
http://www.cs.berkeley.edu/~sailesh
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
