Dave Johansen <davejohansen@xxxxxxxxx> writes: > ... So is there a way to make the > planner perform the same sort of operation and push those same constraints > into the sub-queries on its own? No. As was mentioned upthread, there is a solution for this in 9.1, although it doesn't work in exactly the way you suggest. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance