[ADMIN] IN subselects and index / seq_scan question....

I am having an optimization problem with queries that include IN clauses and subselects. xxx= select version(); version - PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96 The basic query I have

Re: [ADMIN] IN subselects and index / seq_scan question....

Marc Mitchell [EMAIL PROTECTED] writes: I am having an optimization problem with queries that include IN clauses and subselects. The optimizer currently has no clue at all about dealing with IN (subselect), and always converts it into the worst sort of nested-loop plan. I'm hoping to do