Re: Subquery WHERE IN or WHERE EXISTS faster? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Subquery WHERE IN or WHERE EXISTS faster?
Date
Msg-id 29009.1214668423@sss.pgh.pa.us
Whole thread Raw
In response to Subquery WHERE IN or WHERE EXISTS faster?  (Ulrich <ulrich.mierendorff@gmx.net>)
Responses Re: Subquery WHERE IN or WHERE EXISTS faster?  (Ulrich <ulrich.mierendorff@gmx.net>)
Re: Subquery WHERE IN or WHERE EXISTS faster?  ("Jaime Casanova" <jcasanov@systemguards.com.ec>)
List pgsql-performance
Ulrich <ulrich.mierendorff@gmx.net> writes:
> People say that [EXISTS is faster]

People who say that are not reliable authorities, at least as far as
Postgres is concerned.  But it is always a bad idea to extrapolate
results on toy tables to large tables --- quite aside from measurement
noise and caching issues, the planner might pick a different plan when
faced with large tables.  Load up a realistic amount of data and then
see what you get.

            regards, tom lane

pgsql-performance by date:

Previous
From: Ulrich
Date:
Subject: Subquery WHERE IN or WHERE EXISTS faster?
Next
From: Moritz Onken
Date:
Subject: Planner should use index on a LIKE 'foo%' query