2013/5/27 Amit Langote <amitlangote09@xxxxxxxxx>
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@xxxxxxxxxxxx
--
Victor Y. Yegorov
Victor Y. Yegorov
