Postgres Pro
Downloads
Home   >   mailing lists

Re: Question about subselect/IN performance - Mailing list pgsql-performance

From bricklen
Subject Re: Question about subselect/IN performance
Date
Msg-id AANLkTinK05Cvu-4tcotn-U3QBuP5C__ZGbGkx_6QPED6@mail.gmail.com
Whole thread Raw
In response to Re: Question about subselect/IN performance  ("T.H." <calinet6@gmail.com>)
List pgsql-performance
Tree view 
On Tue, Nov 30, 2010 at 3:23 PM, T.H. <calinet6@gmail.com> wrote:
> Just looking into it now, thanks for the suggestion. Is there a reason that
> EXISTS is generally faster than IN for this sort of query?
>
> -Tristan

Exists will return immediately upon finding a match -- assuming there is one.

pgsql-performance by date:

Previous
From: "Pierre C"
Date:
Subject: Re: SELECT INTO large FKyed table is slow
Next
From: "Joshua D. Drake"
Date:
Subject: Re: SELECT INTO large FKyed table is slow