Re: [HACKERS] Multivariate statistics and expression indexes

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.

regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services