Statistics fixes and improvements in face of high fraction of NULLs and/or skewed distribution

ID 503

Title Statistics fixes and improvements in face of high fraction of NULLs and/or skewed distribution

Topic Miscellaneous

Created 2016-02-08 14:04:29

Last modified 2016-04-08 06:41:27 (8 years, 8 months ago)

Latest email 2016-04-05 05:58:42 (8 years, 8 months ago)

Status

2016-03: Returned with feedback

Target version

Authors Alex Shulgin (ash), Tomas Vondra (fuzzycz)

Reviewers Tom Lane (tgl)Become reviewer

Committer Tom Lane (tgl)

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/503
git checkout commitfest/cf/503

Emails

More stable query plans via more predictable column statistics: First at 2015-12-01 15:21:13 by "Shulgin, Oleksandr" <oleksandr.shulgin at zalando.de>
Latest at 2016-04-05 05:58:42 by "Shulgin, Oleksandr" <oleksandr.shulgin at zalando.de>
Latest attachment (better-MCV-cutoff-1.patch) at 2016-04-02 16:37:53 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (better-MCV-cutoff-1.patch) at 2016-04-02 16:37:53 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (0001-Account-for-NULLs-in-ANALYZE-more-strictly.patch) at 2016-03-02 17:56:50 from "Shulgin, Oleksandr" <oleksandr.shulgin at zalando.de> (Patch: Yes)
    Attachment (analyze-better-histogram-v2.patch) at 2016-02-08 14:01:00 from "Shulgin, Oleksandr" <oleksandr.shulgin at zalando.de> (Patch: Yes)
    Attachment (ndistinct-nulls-fix.patch) at 2016-01-23 10:22:08 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (analyze-better-histogram.patch) at 2015-12-01 15:21:13 from "Shulgin, Oleksandr" <oleksandr.shulgin at zalando.de> (Patch: Yes)

History

When	Who	What
2016-04-08 06:41:27	Robert Haas (rhaas)	Closed in commitfest 2016-03 with status: Returned with feedback
2016-04-04 22:28:15	Tom Lane (tgl)	New status: Waiting on Author
2016-04-02 04:04:17	Tom Lane (tgl)	Added tgl as committer
2016-04-01 17:01:20	Tom Lane (tgl)	Added tgl as reviewer
2016-03-18 15:04:39	Tom Lane (tgl)	Removed tgl from reviewers
2016-03-08 21:37:04	Tom Lane (tgl)	Added tgl as reviewer
2016-02-08 14:04:51	Alex Shulgin (ash)	Changed authors to Tomas Vondra (fuzzycz), Alex Shulgin (ash)
2016-02-08 14:04:29	Alex Shulgin (ash)	Attached mail thread CACACo5RFCsMDZrsxwzZ0HsCBY51EttXB=HwZhfp+X7EGRgeSSQ@mail.gmail.com
2016-02-08 14:04:29	Alex Shulgin (ash)	Created patch record