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


When Pivotal Query Optimizer (PQO) is enabled, optimizer_sort_factor controls the cost factor to apply to sorting operations during query optimization. The default value 1 specifies the default sort cost factor. The value is a ratio of increase or decrease from the default factor. For example, a value of 2.0 sets the cost factor at twice the default, and a value of 0.5 sets the factor at half the default.

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

Value Range Default Set Classifications
Decimal > 0 1 master