Re: Extremely irregular query performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Bruce Momjian <pgman@xxxxxxxxxxxxxxxx> 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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux