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 02:29:58
Message-ID: 20210122022958.GC27167@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

This already needs to be rebased on 55dc86eca.

And needs to update rules.out.

And doesn't address this one:

On Sun, Jan 17, 2021 at 10:53:31PM -0600, Justin Pryzby wrote:
> | postgres=# CREATE TABLE t(i int);
> | postgres=# CREATE STATISTICS s2 ON (i+1) ,(i+1+0) FROM t;
> | postgres=# \d t
> | Table "public.t"
> | Column | Type | Collation | Nullable | Default
> | --------+---------+-----------+----------+---------
> | i | integer | | |
> | Indexes:
> | "t_i_idx" btree (i)
> | Statistics objects:
> | "public"."s2" (ndistinct, dependencies, mcv) ON FROM t
>
> on ... what ?

--
Justin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2021-01-22 02:32:41 Re: [PoC] Non-volatile WAL buffer
Previous Message Hou, Zhijie 2021-01-22 02:15:58 RE: Parallel INSERT (INTO ... SELECT ...)