multivariate statistics

Edit

ID 852

Title multivariate statistics

Topic Miscellaneous

Created 2016-10-29 19:26:20

Last modified 2017-04-05 22:39:31 (7 years, 7 months ago)

Latest email 2017-04-05 22:22:26 (7 years, 7 months ago)

Status

2017-03: Committed

2017-01: Moved to next CF

2016-11: Moved to next CF

Target version

Authors Tomas Vondra (fuzzycz)

Reviewers Álvaro Herrera (alvherre), David Rowley (davidrowley)Become reviewer

Committer Simon Riggs (simon)

Links CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/852
git checkout commitfest/cf/852

Emails

WIP: multivariate statistics / proof of concept: First at 2014-10-12 22:00:53 by Tomas Vondra <tv at fuzzy.cz>
Latest at 2017-04-05 22:22:26 by David Rowley <david.rowley at 2ndquadrant.com>
Latest attachment (create_statistics_lock_reduction.v1.patch) at 2017-04-05 18:52:39 from Simon Riggs <simon at 2ndquadrant.com>
    Attachment (create_statistics_lock_reduction.v1.patch) at 2017-04-05 18:52:39 from Simon Riggs <simon at 2ndquadrant.com> (Patch: Yes)
    Attachment (mv_functional-deps_2017-04-06.patch) at 2017-04-05 14:47:44 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (mv_functional-deps_2017-04-04.patch) at 2017-04-04 07:55:34 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (mv_functional-deps_2017-04-01.patch) at 2017-03-31 15:25:12 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (mv_functional-deps_2017-03-31.patch) at 2017-03-30 14:03:06 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-teach-pull_-varno-varattno-_walker-about-RestrictInf.patch.gz) at 2017-03-16 22:20:33 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: No)
    Attachment (extstats_pg_dump_and_comment_support.patch) at 2017-03-16 12:51:43 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (stats-ext-shared-infra-27.patch) at 2017-03-15 20:45:18 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (stats-ext-shared-infra.patch) at 2017-03-14 22:10:49 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-teach-pull_-varno-varattno-_walker-about-Restric-v25.patch.gz) at 2017-03-02 14:53:45 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (0001-teach-pull_-varno-varattno-_walker-about-Restric-v24.patch.gz) at 2017-03-02 03:05:34 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (0001-teach-pull_-varno-varattno-_walker-about-Restric-v23.patch) at 2017-01-30 19:12:35 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-teach-pull_-varno-varattno-_walker-about-Restric-v22.patch) at 2017-01-04 02:35:15 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (multivariate-stats-v21.tgz) at 2016-12-12 21:50:05 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (multivariate-stats-v20.tgz) at 2016-10-29 19:23:34 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (multivariate-stats-v19.tgz) at 2016-08-03 01:58:13 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (multivariate-stats-v18.tgz) at 2016-03-26 02:02:03 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (multivariate-stats-v17.tgz) at 2016-03-24 17:12:58 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (multivariate-stats-v16.tgz) at 2016-03-20 23:34:51 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (0001-teach-pull_-varno-varattno-_walker-about-RestrictInf.patch) at 2016-03-16 13:32:00 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (0008-change-how-we-apply-selectivity-to-number-of-groups-.patch) at 2016-03-13 21:59:38 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (mvstats-segfault-fix.patch) at 2016-03-09 17:21:42 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-teach-pull_-varno-varattno-_walker-about-RestrictInf.patch) at 2016-03-09 15:02:59 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-teach-pull_-varno-varattno-_walker-about-RestrictInf.patch) at 2016-03-09 09:54:09 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (regression.diffs) at 2016-03-09 02:24:43 from Jeff Janes <jeff.janes at gmail.com> (Patch: Yes)
    Attachment (0001-teach-pull_-varno-varattno-_walker-about-RestrictInf.patch) at 2016-03-08 20:13:08 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-teach-pull_-varno-varattno-_walker-about-RestrictInf.patch) at 2016-03-02 14:56:28 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-teach-pull_-varno-varattno-_walker-about-RestrictInf.patch) at 2016-01-19 04:24:07 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-teach-pull_-varno-varattno-_walker-about-RestrictInf.patch) at 2015-12-23 19:07:48 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-Modify-the-estimate-path-to-be-bottom-up-processing.patch) at 2015-07-30 11:26:35 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0002-PoC-Planner-part-refactoring-of-mv-stats-facility.patch) at 2015-07-16 11:51:57 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0006-multi-statistics-estimation-v7.patch) at 2015-05-25 20:43:46 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (mvcoef-poc-20150513.patch) at 2015-05-13 08:31:59 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0006-teach-expression-walker-about-RestrictInfo-because-o.patch) at 2015-05-06 20:03:50 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (multivariate_contrib.patch) at 2015-04-28 17:36:58 from Jeff Janes <jeff.janes at gmail.com> (Patch: Yes)
    Attachment (dependencies.sql) at 2015-03-31 00:26:26 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (0001-shared-infrastructure-and-functional-dependencies.patch) at 2015-03-20 08:33:07 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: No)
    Attachment (0004-multivariate-histograms.patch) at 2015-01-24 20:21:39 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (multivar-stats-v2.patch) at 2014-11-10 02:34:52 from Tomas Vondra <tv at fuzzy.cz> (Patch: Yes)
    Attachment (multivar-stats-v1.patch) at 2014-10-12 22:00:53 from Tomas Vondra <tv at fuzzy.cz> (Patch: Yes)
extended statistics: n-distinct: First at 2017-03-20 19:02:20 by Alvaro Herrera <alvherre at 2ndquadrant.com>
Latest at 2017-03-24 18:26:39 by Alvaro Herrera <alvherre at 2ndquadrant.com>
Latest attachment (extstat-ndistinct-30.patch) at 2017-03-22 21:03:45 from Alvaro Herrera <alvherre at 2ndquadrant.com>
    Attachment (extstat-ndistinct-30.patch) at 2017-03-22 21:03:45 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (split-analyze-h.patch) at 2017-03-20 22:19:05 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (extstat-ndistinct-29.patch) at 2017-03-20 19:02:20 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)

History

When	Who	What
2017-04-05 22:39:31	Simon Riggs (simon)	Closed in commitfest 2017-03 with status: Committed
2017-04-05 22:39:12	Simon Riggs (simon)	Added simon as committer
2017-03-20 19:06:50	Álvaro Herrera (alvherre)	Attached mail thread 20170320190220.ixlaueanxegqd5gr@alvherre.pgsql
2017-03-20 19:06:41	Álvaro Herrera (alvherre)	New status: Ready for Committer
2017-03-13 10:01:04	David Rowley (davidrowley)	New status: Waiting on Author
2017-03-13 10:00:43	David Rowley (davidrowley)	Added davidrowley as reviewer
2017-01-31 04:20:40	Michael Paquier (michael-kun)	Changed reviewers to Álvaro Herrera (alvherre)
2017-01-31 04:20:14	Michael Paquier (michael-kun)	Closed in commitfest 2017-01 with status: Moved to next CF
2017-01-25 05:25:43	Takeshi Ideriha (ideriha)	Removed ideriha from reviewers
2017-01-20 08:54:41	Takeshi Ideriha (ideriha)	Added ideriha as reviewer
2017-01-05 17:23:59	Simon Riggs (simon)	Removed simon from reviewers
2017-01-03 17:15:25	Simon Riggs (simon)	Added simon as reviewer
2016-12-02 12:01:00	Haribabu Kommi (haribabu)	Closed in commitfest 2016-11 with status: Moved to next CF
2016-10-29 19:27:54	Tomas Vondra (fuzzycz)	Deleted annotation "v20 of the patch" from 61e71067-9461-d785-b4a6-6e8a08996d5f@2ndquadrant.com
2016-10-29 19:27:37	Tomas Vondra (fuzzycz)	Added annotation "v20 of the patch" to 61e71067-9461-d785-b4a6-6e8a08996d5f@2ndquadrant.com
2016-10-29 19:26:38	Tomas Vondra (fuzzycz)	Changed authors to Tomas Vondra (fuzzycz)
2016-10-29 19:26:20	Tomas Vondra (fuzzycz)	Attached mail thread 543AFA15.4080608@fuzzy.cz
2016-10-29 19:26:20	Tomas Vondra (fuzzycz)	Created patch record

Edit