Thread: Set enable_seqscan doesn't take effect?
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)
Hi, On 2023-09-28 00:37:41 +0800, jacktby jacktby 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) Sorry to be the grump here: You start several threads a week, often clearly not having done much, if any, prior research. Often even sending the same question to multiple lists. It should not be hard to find an explanation for the behaviour you see here. pgsql-hackers isn't a "do my work for me service". We're hacking on postgres. It's fine to occasionally ask for direction, but you're very clearly exceeding that. Greetings, Andres Freund
On Thu, 28 Sept 2023 at 13:47, jacktby jacktby <jacktby@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
> 2023年9月28日 01:07，Andres Freund <andres@anarazel.de> 写道： > > Hi, > > On 2023-09-28 00:37:41 +0800, jacktby jacktby 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) > > Sorry to be the grump here: > > You start several threads a week, often clearly not having done much, if any, > prior research. Often even sending the same question to multiple lists. It > should not be hard to find an explanation for the behaviour you see here. > > pgsql-hackers isn't a "do my work for me service". We're hacking on > postgres. It's fine to occasionally ask for direction, but you're very clearly > exceeding that. > > Greetings, > > Andres Freund I’m so sorry for that. I think I’m not very familiar with pg, so I ask many naive questions. And I apologize for my behavior.
> 2023年9月28日 01:07，Andres Freund <andres@anarazel.de> 写道： > > Hi, > > On 2023-09-28 00:37:41 +0800, jacktby jacktby 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) > > Sorry to be the grump here: > > You start several threads a week, often clearly not having done much, if any, > prior research. Often even sending the same question to multiple lists. It > should not be hard to find an explanation for the behaviour you see here. > > pgsql-hackers isn't a "do my work for me service". We're hacking on > postgres. It's fine to occasionally ask for direction, but you're very clearly > exceeding that. > > Greetings, > > Andres Freund I’m so sorry for that. I think I’m not very familiar with pg, so I ask many naive questions. And I apologize for my behavior.
On Wednesday, September 27, 2023, jacktby jacktby <jacktby@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)
It wouldn’t cost 10billion to return the first tuple if that setting wasn’t working.
That is the “discouragement” the documentation is referring to.
I do agree the wording in the docs could be improved since it is a bit self-contradictory and unspecific, but it is explicitly clear a plan with sequential scan can still be chosen even with this set to off.
David J.
> 2023年9月28日 01:07，Andres Freund <andres@anarazel.de> 写道： > > Hi, > > On 2023-09-28 00:37:41 +0800, jacktby jacktby 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) > > Sorry to be the grump here: > > You start several threads a week, often clearly not having done much, if any, > prior research. Often even sending the same question to multiple lists. It > should not be hard to find an explanation for the behaviour you see here. > > pgsql-hackers isn't a "do my work for me service". We're hacking on > postgres. It's fine to occasionally ask for direction, but you're very clearly > exceeding that. > > Greetings, > > Andres Freund I’m so sorry for that. I think I’m not very familiar with pg, so I ask many naive questions. And I apologize for my behavior.
2023年9月28日 12:26，David G. Johnston <david.g.johnston@gmail.com> 写道：On Wednesday, September 27, 2023, jacktby jacktby <jacktby@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) It wouldn’t cost 10billion to return the first tuple if that setting wasn’t working.That is the “discouragement” the documentation is referring to.I do agree the wording in the docs could be improved since it is a bit self-contradictory and unspecific, but it is explicitly clear a plan with sequential scan can still be chosen even with this set to off.David J.
On Thu, Sep 28, 2023 at 03:38:28PM +0800, jacktby jacktby wrote:
> > You start several threads a week, often clearly not having done much, if any,
> > prior research. Often even sending the same question to multiple lists. It
> > should not be hard to find an explanation for the behaviour you see here.
> >
> > pgsql-hackers isn't a "do my work for me service". We're hacking on
> > postgres. It's fine to occasionally ask for direction, but you're very clearly
> > exceeding that.
> >
> > Greetings,
> >
> > Andres Freund
> I’m so sorry for that. I think I’m not very familiar with pg, so I ask many naive questions. And I apologize for my
behavior.
I think you might find our IRC channel a more natural fit for getting
your questions answered:
https://www.postgresql.org/community/irc/
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.