Re: Optimization rules for semi and anti joins

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Optimization rules for semi and anti joins
Date: 2009-02-20 16:13:56
Message-ID: 603c8f070902200813o298ac32akdc40325d53a0a7a8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Feb 20, 2009 at 10:59 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> I wrote:
>> Hence semijoins can be rearranged just as freely as inner joins.
>
> I guess nobody checked my work, because that claim is bogus.

I spent some time reading your email and thinking through the cases,
but I completely failed to notice this.

Sorry,

...Robert

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2009-02-20 17:22:58 Re: pg_restore --multi-thread
Previous Message Tom Lane 2009-02-20 15:59:03 Re: Optimization rules for semi and anti joins