Re: [PATCH] Push limit to sort through a subquery

Michael Paquier <michael.paquier@gmail.com>

From: Michael Paquier <michael.paquier@gmail.com>

To: Robert Haas <robertmhaas@gmail.com>

Cc: Douglas Doole <dougdoole@gmail.com>, Konstantin Knizhnik <k.knizhnik@postgrespro.ru>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>

Date: 2017-08-21T22:57:26Z

Lists: pgsql-hackers

On Tue, Aug 22, 2017 at 3:43 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> Works for me.  While I'm sure this won't eclipse previous achievements
> in this area, it still seems worthwhile.

This one is intentional per what happens in the US today? ;)
-- 
Michael

Commits

Propagate sort instrumentation from workers back to leader.
- bf11e7ee2e36 11.0 landed
Push tuple limits through Gather and Gather Merge.
- 3452dc5240da 11.0 landed
Code review for pushing LIMIT through subqueries.
- 3f4c7917b3bc 11.0 landed
Make new regression test case parallel-safe, and improve its output.
- 1177ab1dabf7 11.0 landed
Push limit through subqueries to underlying sort, where possible.
- 1f6d515a67ec 11.0 landed
Move targetlist SRF handling from expression evaluation to new executor node.
- 69f4b9c85f16 10.0 cited