| From: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> |
|---|---|
| To: | Egor Rogov <e(dot)rogov(at)postgrespro(dot)ru>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: pg_stats and range statistics |
| Date: | 2021-06-18 20:31:43 |
| Message-ID: | 55c8ecd4-57d0-5c63-6fe3-1b81e8caea9d@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 6/18/21 6:22 PM, Egor Rogov wrote:
> Hi,
>
> Statistics for range types are not currently exposed in pg_stats view
> (i.e. STATISTIC_KIND_RANGE_LENGTH_HISTOGRAM and
> STATISTIC_KIND_BOUNDS_HISTOGRAM).
>
> Shouldn't they? If so, here is a patch for adding them.
>
I think they should be exposed - I don't see why not to do that. I
noticed this when working on the count-min sketch experiment too, so
thanks for this patch.
FWIW I've added the patch to the next CF:
https://commitfest.postgresql.org/33/3184/
regards
--
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Álvaro Herrera | 2021-06-18 20:59:00 | Re: Race condition in InvalidateObsoleteReplicationSlots() |
| Previous Message | Tomas Vondra | 2021-06-18 20:24:45 | Re: PoC: Using Count-Min Sketch for join cardinality estimation |