Horton

Re: [HACKERS] PATCH: multivariate histograms and MCV lists

Tomas Vondra <tomas.vondra@2ndquadrant.com>

View thread View on postgr.es
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Dean Rasheed <dean.a.rasheed@gmail.com>, David Rowley <david.rowley@2ndquadrant.com>, Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>, Michael Paquier <michael@paquier.xyz>, Andres Freund <andres@anarazel.de>, Thomas Munro <thomas.munro@enterprisedb.com>, Bruce Momjian <bruce@momjian.us>, Mark Dilger <hornschnorter@gmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2019-04-09T16:23:39Z
Lists: pgsql-hackers 
On Tue, Apr 09, 2019 at 12:14:47PM -0400, Alvaro Herrera wrote:
>On 2019-Mar-27, Tomas Vondra wrote:
>
>> Attached are the remaining parts of this patch series - the multivariate
>> histograms, and also a new patch tweaking regression tests for the old
>> statistic types (ndistinct, dependencies) to adopt the function-based
>> approach instead of the regular EXPLAIN.
>>
>> But those are clearly a matter for the future (well, maybe it'd make sense
>> to commit the regression test change now).
>
>IMO it makes sense to get the test patch pushed now.
>

OK, I'll take care of that soon.


cheers

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

Commits

  1. Convert pre-existing stats_ext tests to new style

  2. Add support for multivariate MCV lists

  3. Improve ANALYZE's strategy for finding MCVs.

  4. Clone extended stats in CREATE TABLE (LIKE INCLUDING ALL)

  5. Try again to fix accumulation of parallel worker instrumentation.

  6. Adjust psql \d query to avoid use of @> operator.

  7. Message style fixes

  8. Add security checks to selectivity estimation functions