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

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Seq Scan cost shown to be (cost=10000000000.00..10000000001.10)
Date: 2013-05-27 07:42:24
Message-ID: CA+HiwqHjnZJ9eNs_-98aSSgixQ_YSJdqC9EQLMdcGWMOPp3J4w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sergey Konoplev 2013-05-27 07:58:17 Re: Seq Scan cost shown to be (cost=10000000000.00..10000000001.10)
Previous Message chiru r 2013-05-27 06:18:41 Re: error postgresql remote access windows 7