On Thu, 28 Sept 2023 at 13:47, jacktby jacktby <jack...@gmail.com> wrote: > > postgres=# SET enable_seqscan = off; > SET > postgres=# explain select * from t; > QUERY PLAN > ------------------------------------------------------------------------- > Seq Scan on t (cost=10000000000.00..10000000023.60 rows=1360 width=32) > (1 row) > > postgres=# select * from t; > a > ------- > [1,2] > (1 row)>
It may be worth checking what the manual says about this. I guess if you assume the meaning from the GUC name, then it might be surprising. If you're still surprised after reading the manual then please report back. David