Seq Scan cost shown to be (cost=10000000000.00..10000000001.10) - Mailing list pgsql-general

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