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 estimated acceptable error in the cardinality of the table " a value of 0.5 is supposed to be equivalent to an acceptable error of 50% (this is the default value used in PostgreSQL). If the statistics collected during ANALYZE are not producing good estimates of cardinality for a particular table attribute, decreasing the relative error fraction (accepting less error) tells the system to sample more rows.

Value Range Default Set Classifications
floating point < 1.0 0.25 master