Skip site navigation (1) Skip section navigation (2)

Re: Question about subselect/IN performance

From: "T(dot)H(dot)" <calinet6(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Question about subselect/IN performance
Date: 2010-11-30 23:23:56
Message-ID: id412b$1le5$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-performance
On 11/30/10 5:54 PM, Kevin Grittner wrote:
> "T.H."<calinet6(at)gmail(dot)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

In response to

Responses

pgsql-performance by date

Next:From: Mario SplivaloDate: 2010-11-30 23:24:32
Subject: Re: SELECT INTO large FKyed table is slow
Previous:From: Mario SplivaloDate: 2010-11-30 23:22:33
Subject: Re: SELECT INTO large FKyed table is slow

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group