Hello,
I set enable_seqscan=off and also accidentally dropped the only index
on a table (actually, drop extension pg_bigm cascade) and observe
following:
postgres=# explain select * from testdata where name like '%gi%';
QUERY PLAN
-----------------------------------------------------------------------------
Seq Scan on testdata (cost=10000000000.00..10000000001.10 rows=2 width=71)
Filter: (name ~~ '%gi%'::text)
(2 rows)
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?
--
Amit Langote