Re: Set enable_seqscan doesn't take effect?

On Thu, 28 Sept 2023 at 13:47, jacktby jacktby <jacktby(at)gmail(dot)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