"assaf" <assaf_lehr(at)yahoo(dot)com> writes:
> PostgreSQL version: 8.37
> Description: Poor performance with Left-join where right side does
> not exist
8.4 might be smarter about this case for you. It's hard to tell for sure
with so few details.
regards, tom lane