random_page_cost

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

random_page_cost

Sets the estimate of the cost of a nonsequentially fetched disk page for the legacy query optimizer (planner). This is measured as a multiple of the cost of a sequential page fetch. A higher value makes it more likely a sequential scan will be used, a lower value makes it more likely an index scan will be used.

Value Range Default Set Classifications
floating point 100 master

session

reload