Avoiding plan disasters with LIMIT

Title

CI (CFBot)

Not processed

Stats (from CFBot)

Unknown

Topic

Performance

Tags

Created

2015-01-12 12:25:02

Last modified

2015-05-08 05:54:00 (10 years ago)

Latest email

2015-05-15 20:00:19 (10 years ago)

Status

2015-02 (2015-02-15 – 2015-05-15): Returned with feedback

2014-12 (2014-12-15 – 2015-01-15): Moved to different CF

Target version

Authors

Simon Riggs (simon)

Reviewers

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