Date: Thu, 21 Jan 2021 20:29:58 -0600
From: Justin Pryzby <pryzby@telsasoft.com>
To: Tomas Vondra <tomas.vondra@enterprisedb.com>
Cc: Dean Rasheed <dean.a.rasheed@gmail.com>, pgsql-hackers@postgresql.org
Subject: Re: PoC/WIP: Extended statistics on expressions
Message-ID: <20210122022958.GC27167@telsasoft.com>
References: <20210108023537.GA19743@telsasoft.com>
 <d7c93270-20a0-93cb-f15e-46d7b51b35c1@enterprisedb.com>
 <5305f9cf-3927-06c4-cd5b-e46cbc58bc7f@enterprisedb.com>
 <20210116232208.GB8560@telsasoft.com>
 <2f2a3b3b-93e4-723f-144e-bc21f10d6b61@enterprisedb.com>
 <20210118045331.GF8560@telsasoft.com>
 <CAEZATCVnQccV_Z7AuvbvquaOYxUj+cVFk48pPGASYHFjXWgW5g@mail.gmail.com>
 <3f20da4d-89dc-0912-98d2-b6f0ef06c87f@enterprisedb.com>
 <CAEZATCUuj5FPjtOU2=7Z2pTC8LEvrf79+Go7R8yQ+eE0ezfgfQ@mail.gmail.com>
 <f865af90-c19c-769e-8c65-19692e245479@enterprisedb.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <f865af90-c19c-769e-8c65-19692e245479@enterprisedb.com>
User-Agent: Mutt/1.9.4 (2018-02-28)
Precedence: bulk

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