Maximum amount of entries in the histogram_bounds
The default limit is presently 100 entries for histogram_bounds and
max_common_values fields in pg_stats view. Raising the limit might allow
to be made more accurate estimates scanned rows for postgresql planner.
Globally, this setting is set by default_statistics_target or can be set
on a column-by-column basis using the ALTER TABLE SET STATISTICS command.
What is the maximum value of this setting can be set?
No comments:
Post a Comment