On 2 March 2011 19:38, Robert Haas <robertmhaas@xxxxxxxxx> wrote: > On Thu, Feb 24, 2011 at 11:38 AM, Dave Johansen <davejohansen@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
