optimizer_control

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_control

Controls whether the server configuration parameter optimizer can be changed with SET, the RESET command, or the Greenplum Database utility gpconfig. If the optimizer_control parameter value is on, users can set the optimizer parameter. If the optimizer_control parameter value is off, the optimizer parameter cannot be changed.

Value Range Default Set Classifications
Boolean on master

system

restart

superuser