It would appear that in 7.4 the order of clauses in WHERE affects the
execution time (not output if AND).
I would think that a simple optimization would be to push off evaluation
of a subplan whenever possible by re-arranging AND statements.
In the below example, it gives an order of magnitude speed increase on a
small dataset.