Avoiding plan disasters with LIMIT

Edit
Title Avoiding plan disasters with LIMIT
Topic Performance
Created 2015-01-12 12:25:02
Last modified 2015-05-08 05:54:00 (8 years, 10 months ago)
Latest email 2015-05-15 20:00:19 (8 years, 10 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
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