Push limit through subqueries to underlying sort, where possible.
Douglas Doole, reviewed by Ashutosh Bapat and by me. Minor formatting
change by me.
Discussion: http://postgr.es/m/CADE5jYLuugnEEUsyW6Q_4mZFYTxHxaVCQmGAsF0yiY8ZDggi-w@mail.gmail.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/1f6d515a67ec98194c23a5db25660856c9aab944
Modified Files
--------------
src/backend/executor/nodeLimit.c | 26 +++++++++++++++++
src/test/regress/expected/subselect.out | 52 +++++++++++++++++++++++++++++++++
src/test/regress/sql/subselect.sql | 46 +++++++++++++++++++++++++++++
3 files changed, 124 insertions(+)