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