Database Statistics Sampling Parameters

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

Database Statistics Sampling Parameters

These parameters adjust the amount of data sampled by an ANALYZE operation. Adjusting these parameters affects statistics collection system-wide. You can configure statistics collection on particular tables and columns by using the ALTER TABLE SET STATISTICS clause.

  • default_statistics_target
  • gp_analyze_relative_error