| From: | Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> |
|---|---|
| To: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
| Cc: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: PoC/WIP: Extended statistics on expressions |
| Date: | 2021-01-22 09:00:40 |
| Message-ID: | CAEZATCVjxvLsn_kXKC+dgVo7OGBBNROGq4Ok5N1QAoMN7Bg8gQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, 22 Jan 2021 at 04:46, Justin Pryzby <pryzby(at)telsasoft(dot)com> wrote:
>
> I think you'll maybe have to do something better - this seems a bit too weird:
>
> | postgres=# CREATE STATISTICS s2 ON (i+1) ,i FROM t;
> | postgres=# \d t
> | ...
> | "public"."s2" (ndistinct, dependencies, mcv) ON i FROM t
>
I guess that's not surprising, given that old psql knows nothing about
expressions in stats.
In general, I think connecting old versions of psql to newer servers
is not supported. You're lucky if \d works at all. So it shouldn't be
this patch's responsibility to make that output nicer.
Regards,
Dean
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2021-01-22 09:11:54 | Re: adding wait_start column to pg_locks |
| Previous Message | tsunakawa.takay@fujitsu.com | 2021-01-22 08:52:07 | RE: Parallel INSERT (INTO ... SELECT ...) |