Re: Question about subselect/IN performance

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "T(dot)H(dot)" <calinet6(at)gmail(dot)com>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: Question about subselect/IN performance
Date: 2010-11-30 22:54:55
Message-ID: 4CF52C5F0200002500037FBA@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mario Splivalo 2010-11-30 23:22:33 Re: SELECT INTO large FKyed table is slow
Previous Message Pierre C 2010-11-30 22:35:04 Re: Simple database, multiple instances?