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

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: (view raw, whole thread or download thread mbox)
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?

In response to


pgsql-performance by date

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

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