Re: enable_seqscan to off -> initial cost 10000000000 - Mailing list pgsql-general

From Ron
Subject Re: enable_seqscan to off -> initial cost 10000000000
Date
Msg-id ba232e34-ae0f-716e-67c3-268cdcf146ac@gmail.com
Whole thread Raw
In response to enable_seqscan to off -> initial cost 10000000000  (Luca Ferrari <fluca1978@gmail.com>)
Responses Re: enable_seqscan to off -> initial cost 10000000000  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-general
On 4/23/21 10:39 AM, Luca Ferrari wrote:
> Hi all,
> this could be trivial, but I would like an explaination: if I turn off
> sequential scans on a table without indexes, the same access plan is
> increased by a 10000000000 factor. I suspect this is a warning for me
> to remind that something is misconfigured, or is there anothe reason?

Maybe I'm missing something, but in "a table without indexes", what else is 
there besides sequential scan?

-- 
Angular momentum makes the world go 'round.



pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: enable_seqscan to off -> initial cost 10000000000
Next
From: Eric Hill
Date:
Subject: server process exited with code 1