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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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