| From: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> |
|---|---|
| To: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
| Subject: | Re: pg_stats_ext view does not seem all that useful |
| Date: | 2017-04-10 23:22:18 |
| Message-ID: | f27920e5-b144-4dde-28ab-74e247f63e4e@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 04/10/2017 12:12 PM, David Rowley wrote:
> During my review and time spent working on the functional dependencies
> part of extended statistics I wondered what was the use for the
> pg_stats_ext view. I was unsure why the length of the serialised
> dependencies was useful.
>
> Perhaps we could improve the view, but I'm not all that sure what
> value it would add. Maybe we need to discuss this, but in the
> meantime, I've attached a patch which just removes the view completely
>
Yeah, let's get rid of the view. It was quite useful before introducing
the custom data types (and implicit casts to text), because
pg_statistic_ext would simply return the whole bytea value. But since
then the view kinda lost the purpose and no one really noticed.
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2017-04-10 23:34:50 | Re: Patch: Write Amplification Reduction Method (WARM) |
| Previous Message | Bruce Momjian | 2017-04-10 23:19:27 | Re: Patch: Write Amplification Reduction Method (WARM) |