Postgres Pro
Downloads
Home   >   mailing lists

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 11687.1214801324@sss.pgh.pa.us
Whole thread Raw
In response to Re: Subquery WHERE IN or WHERE EXISTS faster?  ("Jaime Casanova" <jcasanov@systemguards.com.ec>)
List pgsql-performance
Tree view 
"Jaime Casanova" <jcasanov@systemguards.com.ec> writes:
> i've made some queries run faster using EXISTS instead of large IN
> clauses... actually, it was NOT EXISTS replacing a NOT IN

That's just about entirely unrelated ...

            regards, tom lane

pgsql-performance by date:

Previous
From: "Jaime Casanova"
Date:
Subject: Re: Subquery WHERE IN or WHERE EXISTS faster?
Next
From: Rusty Conover
Date:
Subject: Re: Subquery WHERE IN or WHERE EXISTS faster?