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