On 2 March 2011 19:38, Robert Haas <robertmhaas@gmail.com> wrote:
> On Thu, Feb 24, 2011 at 11:38 AM, Dave Johansen <davejohansen@gmail.com> wrote:
>> I also just noticed that an ORDER BY x LIMIT n optimization is not pushed
>> down through the UNION ALL as well. I understand that this may be a little
>> trickier because the ORDER BY and LIMIT would need to be applied to the
>> subqueries and then re-applied after the APPEND,
>
> PostgreSQL 9.1 will know how to do this, FWIW.
Out of curiosity, what was the commit for this?
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935