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

Title

CI (CFBot)

Not processed

Stats (from CFBot)

Unknown

Topic

Miscellaneous

Created

2016-02-08 14:04:29

Last modified

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

Latest email

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

Status

2016-03: Returned with feedback

Target version

Authors

Alex Shulgin (ash), Tomas Vondra (fuzzycz)

Reviewers

Committer

Tom Lane (tgl)

Links

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