Re: enable_seqscan to off -> initial cost 10000000000

Поиск
Список
Период
Сортировка
От Ron
Тема Re: enable_seqscan to off -> initial cost 10000000000
Дата
Msg-id ba232e34-ae0f-716e-67c3-268cdcf146ac@gmail.com
обсуждение исходный текст
Ответ на enable_seqscan to off -> initial cost 10000000000  (Luca Ferrari <fluca1978@gmail.com>)
Ответы Re: enable_seqscan to off -> initial cost 10000000000  (David Rowley <dgrowleyml@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: enable_seqscan to off -> initial cost 10000000000
Следующее
От: Eric Hill
Дата:
Сообщение: server process exited with code 1