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. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
