Re: [HACKERS] Multivariate statistics and expression indexes - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Multivariate statistics and expression indexes
Date
Msg-id 20170221004934.GB13919@momjian.us
Whole thread Raw
In response to Re: [HACKERS] Multivariate statistics and expression indexes  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers
On Tue, Feb 21, 2017 at 01:27:53AM +0100, Tomas Vondra wrote:
> On 02/21/2017 12:13 AM, Bruce Momjian wrote:
> >At the risk of asking a stupid question, we already have optimizer
> >statistics on expression indexes.  In what sense are we using this for
> >multi-variate statistics, and in what sense can't we.
> >
> 
> We're not using that at all, because those are really orthogonal features.
> Even with expression indexes, the statistics are per attribute, and the
> attributes are treated as independent.
> 
> There was a proposal to also allow creating statistics on expressions
> (without having to create an index), but that's not supported yet.

OK, thanks.  I had to ask.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +



pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: [HACKERS] PATCH: two slab-like memory allocators
Next
From: Michael Paquier
Date:
Subject: Re: [HACKERS] SCRAM authentication, take three