Re: enable_seqscan to off -> initial cost 10000000000

2021-04-23 Thread David Rowley
On Sat, 24 Apr 2021 at 03:44, Ron wrote: > > 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 100 factor. I suspect thi

Re: enable_seqscan to off -> initial cost 10000000000

2021-04-23 Thread Ron
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 100 factor. I suspect this is a warning for me to remind that something is misconfigu

Re: enable_seqscan to off -> initial cost 10000000000

2021-04-23 Thread Stephen Frost
Greetings, * Luca Ferrari (fluca1...@gmail.com) wrote: > 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 100 factor. I suspect this is a warning for me > to remind that something

enable_seqscan to off -> initial cost 10000000000

2021-04-23 Thread Luca Ferrari
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 100 factor. I suspect this is a warning for me to remind that something is misconfigured, or is there anothe reason? testdb=# c