Re: Highly obscure and erratic - Mailing list pgsql-general

> What does explain show for the exists version?

suryadb=# explain select * from dbmedia where EXISTS (select ID from wdmedia where word='whatever' AND dbmedia.id=id )
LIMIT200; 
NOTICE:  QUERY PLAN:

Limit  (cost=0.00..1006732.42 rows=200 width=76)
  ->  Seq Scan on dbmedia  (cost=0.00..507810931.25 rows=100883 width=76)
          SubPlan
                    ->  Index Scan using wdkmedia on wdmedia  (cost=0.00..5033.63 rows=1 width=4)

                    EXPLAIN

still seq scan :((
someone please fix this bug :(

--
------
Varun
Once I finally figured out all of life's answers.....they changed the questions.