Re: Join vs Subquery

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Brian Herlihy <btherl(at)yahoo(dot)com(dot)au>
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Join vs Subquery
Date: 2007-05-03 14:23:42
Message-ID: 3608.1178202222@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Brian Herlihy <btherl(at)yahoo(dot)com(dot)au> 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2007-05-03 14:45:48 pg_stat_* collection
Previous Message Gregory Stark 2007-05-03 11:46:31 Re: Join vs Subquery