Avoiding plan disasters with LIMIT

Edit
ID 29
Title Avoiding plan disasters with LIMIT
Topic Performance
Created 2015-01-12 12:25:02
Last modified 2015-05-08 05:54:00 (9 years, 5 months ago)
Latest email 2015-05-15 20:00:19 (9 years, 5 months ago)
Status
2015-02: Returned with feedback
2014-12: Moved to next CF
Target version
Authors Simon Riggs (simon)
Reviewers Become reviewer
Committer
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/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
Edit