Optimizer patch moving evaluation of non-trivial target list expressions in case of ORDER BY+LIMIT to projection after limit.

Title

Topic

Performance

Created

2016-01-18 16:24:27

Last modified

2016-03-11 17:28:11 (8 years, 8 months ago)

Latest email

2016-03-11 01:45:34 (8 years, 8 months ago)

Status

2016-03: Committed

Target version

Authors

Konstantin Knizhnik (knizhnik)

Reviewers

Committer

Tom Lane (tgl)

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

Emails

Optimizer questions: First at 2016-01-05 14:55:28 by konstantin knizhnik <k.knizhnik at postgrespro.ru>
Latest at 2016-03-11 01:45:34 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (postpone-tlist-2.patch) at 2016-03-11 01:45:34 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (postpone-tlist-2.patch) at 2016-03-11 01:45:34 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (conditionally-postpone-tlist-eval-to-after-sort-1.patch) at 2016-03-09 22:56:52 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (tlist.patch) at 2016-03-08 18:44:03 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (optimizer-limit.patch) at 2016-01-08 08:58:12 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (limit.patch) at 2016-01-07 19:43:21 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)

History

When	Who	What
2016-03-11 17:28:11	Tom Lane (tgl)	Closed in commitfest 2016-03 with status: Committed
2016-03-11 17:28:11	Tom Lane (tgl)	Changed committer to tgl
2016-03-09 22:59:11	Tom Lane (tgl)	Added tgl as reviewer
2016-03-08 04:02:01	Tom Lane (tgl)	New status: Waiting on Author
2016-02-02 10:57:55	Álvaro Herrera (alvherre)	Changed authors to Konstantin Knizhnik (knizhnik)
2016-01-18 16:24:28	Konstantin Knizhnik (knizhnik)	Attached mail thread 9879B786-E011-44A1-91B8-54649B84106D@postgrespro.ru
2016-01-18 16:24:27	Konstantin Knizhnik (knizhnik)	Created patch record