On Tue, 2008-09-02 at 12:02 -0400, Tom Lane wrote:
> Simon Riggs <simon@2ndQuadrant.com> writes:
> >> Oh. How does the query look like after removing the join, then?
>
> > Same answer, just slower. Removing the join makes the access to a into a
> > SeqScan, whereas it was a two-table index plan when both tables present.
>
> I don't really believe this...
Yes, this will be changed. No need to review further at this stage.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support