Bruce Momjian <pgman@candle.pha.pa.us> writes: > <para> > ! Genetic query optimization (<acronym>GEQO</acronym>) randomly > ! tests execution plans. Therefore, when the number of tables > ! exceeds <varname>geqo</> and genetic query optimization is in use, > ! the execution plan will change each time the statement is executed. > </para>
geqo_threshold, please --- geqo is a boolean. Possibly better wording: Therefore, when the number of tables exceeds geqo_threshold causing genetic query optimization to be used, the execution plan is likely to change each time the statement is executed. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster