Re: Pushing IN (subquery) down through UNION ALL?

On Thu, Feb 24, 2011 at 11:38 AM, Dave Johansen <davejohansen@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.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company