On 2 March 2011 19:38, Robert Haas <robertmh...@gmail.com> wrote: > On Thu, Feb 24, 2011 at 11:38 AM, Dave Johansen <davejohan...@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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
