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 |