Re: JOIN performance

"Dean Gibson (DB Administrator)" <postgresql3@ultimeth.com> writes:
> It turns out that even when I removed the CASE statement from the VIEW, the 
> performance problem remained.  I had to remove the conditional as well from 
> the VIEW.

> cancel_date < expire_date AS canceled,

Yuck :-(

> Do you know why?  I'm running 7.3.4, by the way.

7.3 is even stupider than 7.4, is why ...

In 7.3 only a view whose targetlist consists of simple column references
can be pulled up into the nullable side of an outer join.
        regards, tom lane