INTERSECT / where id IN (etc..) - Mailing list pgsql-sql

From James Cooper
Subject INTERSECT / where id IN (etc..)
Date
Msg-id 003701c2e37a$fe0bb2d0$c900a8c0@jax
Whole thread Raw
Responses Re: INTERSECT / where id IN (etc..)
List pgsql-sql
Greetings.
 
I was wondering if somone out there could shed some light on a query performance issie I have.
I have a large lookup table that I query with nested selects to gain the INTERSECT result from.
 
the bigger this table gets the slower the performance.
 
1. is creating a temp table and only intersecting from this a good idea?
2. does having a where clause in your select before your nested intersects change the amount of work the query
 
i.e. select person_id from person where person_id < 5000 And person_id IN
    as opposed to
    select person_id from person where person_id IN(etc)
 
thoughts?
 

pgsql-sql by date:

Previous
From: Gary Stainburn
Date:
Subject: Re: sort / limit / range problem
Next
From: "Aspire Something"
Date:
Subject: Arrays Or Loop