Postgresql: how statistics are collected in the histogram_bounds
The documentation of Postgresql is the explanation that this
histogram_bounds field in pg_stats.
The histogram divides the range into equal frequency buckets, so all we
have to do is locate the bucket that our value is in and count part of it
and all of the ones before.
But I still can not understand how the algorithms based on this field. I
would like to describe in more detail how ANALYZE puts value in this
field.
No comments:
Post a Comment