gp_analyze_relative_error
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 session reload |