>>>>> "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

Reply via email to