Disable Genetic Optimizer (GEQO) Option

From: "Jan-Peter Seifert" <Jan-Peter(dot)Seifert(at)gmx(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Disable Genetic Optimizer (GEQO) Option
Date: 2015-06-11 13:19:51
Message-ID: trinity-bca59d8c-00eb-4f94-9e64-2b349b98c6d7-1434028791211@3capp-gmx-bs57
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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 convenience feature rather than having to type it in the connect settings. This feature was added when we noticed the backend seemed 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

Browse pgsql-odbc by date

  From Date Subject
Next Message Nikhil Deshpande 2015-06-13 00:42:30 [PATCH] Remove unncessary localtime() calls during data type conversion
Previous Message Michael Paquier 2015-06-11 00:02:50 Re: Compiling on Haiku with iODBC