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 legacy query optimizer (planner) estimates.

Value Range Default Set Classifications
integer > 0 25 master

session

reload