default_statistics_target

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

default_statistics_target

Sets the default statistics target for table columns that have not had a column-specific target set via ALTER TABLE SET STATISTICS. Larger values increase the time needed to do ANALYZE, but may improve the quality of the planner's estimates.

Value Range Default Set Classifications
integer > 0 25 master

session

reload