optimizer_enable_master_only_queries

A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.

optimizer_enable_master_only_queries

When the Pivotal Query Optimizer is enabled (the server configuration parameter optimizer is on), this parameter allows the Pivotal Query Optimizer to execute catalog queries that run only on the Greenplum Database master. For the default value off, only the legacy query optimizer can execute catalog queries that run only on the Greenplum Database master.

The parameter can be set for a database system, an individual database, or a session or query.

Note: Enabling this parameter decreases performance of short running catalog queries. To avoid this issue, set this parameter only for a session or a query.

For information about the Pivotal Query Optimizer, see the Greenplum Database Administrator Guide.

Value Range Default Set Classifications
Boolean off master

session

reload