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