Re: PoC/WIP: Extended statistics on expressions

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>
Cc: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: PoC/WIP: Extended statistics on expressions
Date: 2021-01-22 04:01:01
Message-ID: 20210122040101.GF27167@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Jan 22, 2021 at 04:49:51AM +0100, Tomas Vondra wrote:
> > > | Statistics objects:
> > > | "public"."s2" (ndistinct, dependencies, mcv) ON FROM t
>
> Umm, for me that prints:

> "public"."s2" ON ((i + 1)), (((i + 1) + 0)) FROM t
>
> which I think is OK. But maybe there's something else to trigger the
> problem?

Oh. It's because I was using /usr/bin/psql and not ./src/bin/psql.
I think it's considered ok if old client's \d commands don't work on new
server, but it's not clear to me if it's ok if they misbehave. It's almost
better it made an ERROR.

In any case, why are there so many parentheses ?

--
Justin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Nancarrow 2021-01-22 04:11:31 Re: Parallel INSERT (INTO ... SELECT ...)
Previous Message Tomas Vondra 2021-01-22 03:49:51 Re: PoC/WIP: Extended statistics on expressions