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