yugabyte-db icon indicating copy to clipboard operation
yugabyte-db copied to clipboard

Published 20 hours ago • verified publisher icon yugabyte

[YSQL] Add MCV support in CREATE STATISTICS commands

Open sushantrmishra opened this issue 2 years ago • 0 comments

Jira Link: DB-3044

Description

PG14 CREATE STATISTICS commands support MCV also. From https://www.postgresql.org/docs/current/sql-createstatistics.html (PG14).

A multivariate statistics kind to be computed in this statistics object. Currently supported kinds are ndistinct, which enables n-distinct statistics, dependencies, which enables functional dependency statistics, and mcv which enables most-common values lists.

As we are enabling CREATE STATISTICS ( GH#7788 ) , we should add the support for MCV as well. This would require importing PG14 relevant commits.

sushantrmishra avatar Jul 23 '22 04:07 sushantrmishra