Avoiding plan disasters with LIMIT

Title

Topic

Performance

Created

2015-01-12 12:25:02

Last modified

2015-05-08 05:54:00 (9 years, 6 months ago)

Latest email

2015-05-15 20:00:19 (9 years, 6 months ago)

Status

2015-02: Returned with feedback

2014-12: Moved to next CF

Target version

Authors

Simon Riggs (simon)

Reviewers

Committer

Links

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

Emails

Yet another abort-early plan disaster on 9.3: First at 2014-09-18 00:11:33 by Josh Berkus <josh at agliodbs.com>
Latest at 2015-05-15 20:00:19 by Josh Berkus <josh at agliodbs.com>
Latest attachment (ndistinct.sql) at 2015-03-31 19:02:29 from Tomas Vondra <tomas.vondra at 2ndquadrant.com>
    Attachment (ndistinct.sql) at 2015-03-31 19:02:29 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (enable_sorted_path.v1a.patch) at 2014-12-17 07:55:29 from Simon Riggs <simon at 2ndQuadrant.com> (Patch: Yes)
    Attachment (pettus_sel.sql) at 2014-12-12 03:31:45 from Simon Riggs <simon at 2ndQuadrant.com> (Patch: No)
    Attachment (avoid_limit_pushdown.v4.patch) at 2014-12-12 03:22:44 from Simon Riggs <simon at 2ndQuadrant.com> (Patch: Yes)
    Attachment (ndistinct-estimator-v3.patch) at 2014-12-07 01:54:14 from Tomas Vondra <tv at fuzzy.cz> (Patch: Yes)
    Attachment (avoid_limit_pushdown.v3.patch) at 2014-12-05 06:46:15 from Simon Riggs <simon at 2ndQuadrant.com> (Patch: Yes)
    Attachment (ndistinct-estimator-v2.patch) at 2014-11-23 20:19:56 from Tomas Vondra <tv at fuzzy.cz> (Patch: Yes)
    Attachment (ndistinct.sql) at 2014-10-10 17:53:36 from Tomas Vondra <tv at fuzzy.cz> (Patch: No)

History

When	Who	What
2015-05-08 05:54:00	Andres Freund (andresfreund)	Closed in commitfest 2015-02 with status: Returned with feedback
2015-02-13 07:15:38	Michael Paquier (michael-kun)	Closed in commitfest 2014-12 with status: Returned with Feedback
2015-01-12 12:25:09	Michael Paquier (michael-kun)	Changed authors to Simon Riggs (simon)
2015-01-12 12:25:02	Michael Paquier (michael-kun)	Attached mail thread 541A2335.3060100@agliodbs.com
2015-01-12 12:25:02	Michael Paquier (michael-kun)	Created patch record