Re: insane index scan times

Sergei Shelukhin escribió:

> explain select * from entries inner join stuff on entries.id =
> stuff.id;
> 
>  ->  Seq Scan on stuff  (cost=0.00..193344.00 rows=12550400 width=12)
> 
> 
> set enable_seqscan = off;
> 
> explain select * from entries inner join stuff on entries.id =
> stuff.id;
> 
>  ->  Index Scan using blah on stuff  (cost=0.00..25406232.30
> rows=12550400 width=12)
> 
> Query execution resuls are consistent w/explain. wtf? no I mean,
> WTF?????!!!!!!!!!!!!!!!!!!!
> 
> Sorry. But I 'm amazed.

I am not.  You are asking it to give you 12 million rows -- so it does.
What's the surprise if it takes long?

Do you really want to have all 12 million rows as a result?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.