Re: Reduce LEFT/FULL JOIN to ANTI JOIN in more cases - Mailing list pgsql-hackers

From wenhui qiu
Subject Re: Reduce LEFT/FULL JOIN to ANTI JOIN in more cases
Date
Msg-id CAGjGUA+wc8jrRQ0kYRERaHJEX1zSPHq8O44ZAV06KippcsXKDw@mail.gmail.com
Whole thread
List pgsql-hackers
HI Richard

> I considered that.  It would give the same answer, but I think
> carrying the raw quals is the better deal: pass2 runs
> find_nonnullable_vars only when it actually has forced-null vars in
> hand, so the common case of outer joins without any IS NULL quals pays
> nothing, whereas deriving the set in pass1 would walk every collected
> qual for every query containing an outer join.
Thank you for your explanation, 

> 0001 and 0002 are as before. 
   0003,0004   LGTM, I will invite other Hackers to take a look.


Thanks  

pgsql-hackers by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Re: [PATCH] Add pg_get_table_ddl() to reconstruct CREATE TABLE statements
Next
From: Jakub Wartak
Date:
Subject: Re: Allow pg_log_backend_memory_contexts() for postmaster