Re: NOT IN doesn't use index? (fwd) - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: NOT IN doesn't use index? (fwd)
Date
Msg-id 20030504120511.M43020-100000@houston.familyhealth.com.au
Whole thread Raw
In response to Re: NOT IN doesn't use index? (fwd)  (Joe Conway <mail@joeconway.com>)
List pgsql-performance
AFAIK, it's only the IN (large subquery) form that is slow...

Chris

On Sat, 3 May 2003, Joe Conway wrote:

> Becky Neville wrote:
> > Here is the EXPLAIN output from the two queries.  The first is the one
> > that uses WHERE field NOT IN ( 'a','b' etc ).  The second is the (much
>
> Unless you are working with Postgres 7.4devel (i.e. cvs HEAD), the IN
> construct is notoriously slow in Postgres. In cvs it is vastly improved.
>
> Also, as I mentioned in the other reply, send in "EXPLAIN ANALYZE"
> results instead of "EXPLAIN" (and make sure you run "VACUUM ANALYZE" first).
>
> Joe
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>


pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Suggestions wanted for 7.2.4 query
Next
From: Tom Lane
Date:
Subject: Re: Suggestions wanted for 7.2.4 query