WARNING: geqo : setting is ignored because it is defunct

Products

• Services Suite

Issue/Introduction

Symptoms:

Master's pg_log displays following messages -

"WARNING","01000","""geqo"": setting is ignored because it is defunct",,,,,,,0,,"guc.c",9564,

 

Environment

Cause

This is a simple warning message indicating that the specified parameter "geqo" has been deprecated and thus ignored. GUC "geqo" was used in the past to control the old style optimizer called 'Genetic Query Optimizer' but the feature has been removed long time ago. It is very rare to see a user trying to use this feature; however, some client connectivity packages still try to set this param during connection initialization.

Resolution

There is no harm in seeing this warning messages at all. Users can safely ignore this messages.