2013/5/27 Amit Langote <amitlangote09(at)gmail(dot)com>
> Although, I suspect the (dropped index + enable_seqscan) causes this,
> is the cost shown in explain output some kind of default max or
> something like that for such abnormal cases?
>
When one uses “enable_” settings to adjust planner behavior, PostgreSQL
just sets really high costs for the operations affected (like the one you
see).
As SeqScan is the only possible way to execute your query, it is still
choosen.
Somewhat related thread:
http://www.postgresql.org/message-id/4D5B06AC.2020700@lelarge.info
--
Victor Y. Yegorov