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


Sets the number of primary segment instances for the legacy query optimizer (planner) to assume in its cost and size estimates. If 0, then the value used is the actual number of primary segments. This variable affects the legacy optimizer's estimates of the number of rows handled by each sending and receiving process in Motion operators.

Value Range Default Set Classifications
0-n 0 master