Re: On query rewrite

>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:
   Tom> This particular issue is handled as part of our Path   Tom> enumeration mechanism, but the more hard-wired
sortsof   Tom> transformations that you are asking about live mostly in
 

Thanks again. To confirm the actual cost comparison with plan
enumeration is a dynamic programming algorithm, is it not ?
Selinger-style with 2-way join paths enumerated, then 3-way using the
best 2-way etc. ? 

BTW, do lots of people use the GEQO ? 
   Tom> optimizer/prep/* and plan/planner.c.  In particular you   Tom> probably want to look at prepjointree.c and
prepqual.c.  Tom> (Note prepqual also looks considerably different in CVS tip   Tom> than in prior releases.)
 

Thanks .. I've extracted cvstip .. sigh .. one of these days I'll have
to do another merge with the TelegraphCQ code. You guys hack too much :-)

-- 
Pip-pip
Sailesh
http://www.cs.berkeley.edu/~sailesh