Thread: Disable Genetic Optimizer (GEQO) Option

Disable Genetic Optimizer (GEQO) Option

From
"Jan-Peter Seifert"
Date:
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