Brian Herlihy <btherl@yahoo.com.au> writes:
> The issue: the second query results in a lower cost estimate. I am wondering why the second query plan was not
chosenfor the first query.
8.1 is incapable of pushing indexable join conditions down below an Append.
Try 8.2.
regards, tom lane