> Perhaps if we develop a slightly more complex measure to compare against
> the GEQO threshold, we can do better in deciding when to kick in GEQO.
> A brain-dead suggestion is number of tables + number of indexes ...
> does anyone know whether that is a good measure of the number of cases
> considered in the optimizer?
That is an excellent suggestion. We have always seen 6-table joins that
are short with geqo, and some longer. Perhaps that is the cause.
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026