Seq Scan cost shown to be (cost=10000000000.00..10000000001.10)

[Amit Langote <amitlangote09@xxxxxxxxx>]

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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general