Postgres Pro
Downloads
Home   >   mailing lists

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

From Kevin Grittner
Subject Re: Question about subselect/IN performance
Date
Msg-id 4CF52C5F0200002500037FBA@gw.wicourts.gov
Whole thread Raw
In response to Question about subselect/IN performance  ("T.H." <calinet6@gmail.com>)
Responses Re: Question about subselect/IN performance
List pgsql-performance
Tree view 
"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

pgsql-performance by date:

Previous
From: "Pierre C"
Date:
Subject: Re: Simple database, multiple instances?
Next
From: Mario Splivalo
Date:
Subject: Re: SELECT INTO large FKyed table is slow