Brian Herlihy <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly