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

From T.H.
Subject Re: Question about subselect/IN performance
Date
Msg-id id412b$1le5$1@news.hub.org
Whole thread Raw
In response to Re: Question about subselect/IN performance  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Question about subselect/IN performance
List pgsql-performance
On 11/30/10 5:54 PM, Kevin Grittner wrote:
> "T.H."<calinet6@gmail.com>  wrote:
>
>> Also, are there any better ways you can think of doing such an IN
>> query, using non-subselect means that might be more efficient?
>
> Have you tried the EXISTS predicate?
>
> -Kevin
>

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

pgsql-performance by date:

Previous
From: Mario Splivalo
Date:
Subject: Re: SELECT INTO large FKyed table is slow
Next
From: Mark Kirkwood
Date:
Subject: Re: SELECT INTO large FKyed table is slow