Re: NOT IN doesn't use index? (fwd)

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Becky Neville <rebecca(dot)neville(at)yale(dot)edu>, andrew(at)libertyrms(dot)info
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: NOT IN doesn't use index? (fwd)
Date: 2003-05-03 18:34:40
Message-ID: 200305031134.40508.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Becky,

> 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
> faster) one
> that uses WHERE NOT (field = 'a' and field = 'b' etc).

We still can't help you if you're not posting your actual queries. We have no
idea what's in query3.sql. We're not clairvoyant, y'know.

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Joe Conway 2003-05-03 18:34:55 Re: NOT IN doesn't use index? (fwd)
Previous Message Josh Berkus 2003-05-03 18:32:56 Re: why is the db so slow?