| From: | Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com> |
|---|---|
| To: | Vik Fearing <vik(dot)fearing(at)dalibo(dot)com> |
| Cc: | Steve Crawford <scrawford(at)pinpointresearch(dot)com>, PostgreSQL General Discussion Forum <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: NOT IN and NOT EXIST |
| Date: | 2014-07-08 03:56:53 |
| Message-ID: | CADp-Sm6vQnFrNv71516mkOtcUR+_dawkftWkbiW8VOOma1Z-fQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, Jul 6, 2014 at 7:14 AM, Vik Fearing <vik(dot)fearing(at)dalibo(dot)com> wrote:
> > NOT EXISTS translates to HASH ANTI JOIN and NOT IN translates to NOT
> > (HASHED) operation.
> >
> > Given that the columns used in NOT IN clause (for outer as well as
> > inner) are NOT NULL, should not it translate a NOT IN plan similar to
> > NOT EXISTS plan?
>
> It will, hopefully in 9.5.
>
> https://commitfest.postgresql.org/action/patch_view?id=1487
Cool!
Will be looking forward to it! But seems a long way from now...
Best Regards,
*Sameer Kumar | Database Consultant*
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
M: *+65 8110 0350* T: +65 6438 3504 | www.ashnik.com
*[image: icons]*
[image: Email patch] <http://www.ashnik.com/>
This email may contain confidential, privileged or copyright material and
is solely for the use of the intended recipient(s).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pujol Mathieu | 2014-07-08 07:01:56 | Re: conditional IF statements in postgresql |
| Previous Message | Tom Lane | 2014-07-07 23:14:53 | Re: [ADMIN] WARNING: database must be vacuumed within 8439472 transactions |