On Wed, Jul 10, 2013 at 1:11 PM, Hannu Krosing <ha...@2ndquadrant.com> wrote: > On 07/10/2013 09:18 AM, Atri Sharma wrote: >>> Can you please post an example of such a join removal? I mean a query before >>> and after the removal. Thanks, >> Courtesy Robert Haas: >> >> SELECT foo.x, foo.y, foo.z FROM foo WHERE foo.x = bar.x >> >> Conditions: >> >> 1) foo.x is not null. > I guess that this is also not needed. you can just remove rows where > > foo.x is null > > That is, replace the join with "foo.x is not null"
Yeah, sounds good. We should explore it further. Regards, Atri -- Regards, Atri l'apprenant -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers