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

Re: Question about subselect/IN performance

From: bricklen <bricklen(at)gmail(dot)com>
To: "T(dot)H(dot)" <calinet6(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Question about subselect/IN performance
Date: 2010-12-01 01:32:16
Message-ID: AANLkTinK05Cvu-4tcotn-U3QBuP5C__ZGbGkx_6QPED6@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Tue, Nov 30, 2010 at 3:23 PM, T.H. <calinet6(at)gmail(dot)com> wrote:
> 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

Exists will return immediately upon finding a match -- assuming there is one.

In response to

pgsql-performance by date

Next:From: Joshua D. DrakeDate: 2010-12-01 01:47:32
Subject: Re: SELECT INTO large FKyed table is slow
Previous:From: Pierre CDate: 2010-12-01 00:51:33
Subject: Re: SELECT INTO large FKyed table is slow

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