Обсуждение: Disable Genetic Optimizer (GEQO) Option

Поиск
Список
Период
Сортировка

Disable Genetic Optimizer (GEQO) Option

От
"Jan-Peter Seifert"
Дата:
Hello,

I wonder about this option which isn't even officially documented anymore:
https://odbc.postgresql.org/docs/config.html

On http://www.postgresql.org/message-id/attachment/15329/config.html it's just:
Disable Genetic Optimizer: Automatically turns off the backend genetic optimizer at connection time. This is a
conveniencefeature rather than having to type it in the connect settings. This feature was added when we noticed the
backendseemed to have big problems optimizing some queries. 

Did someone experience performance troubles with activated GEQO (when using psqlODBC) 'recently' or is it just a
'legacy'option? 

Best regards,

Peter