Re: Set enable_seqscan doesn't take effect? - Mailing list pgsql-hackers

From jacktby jacktby
Subject Re: Set enable_seqscan doesn't take effect?
Date
Msg-id B30B5D52-CF30-4A50-A672-4D2C3858F9E1@gmail.com
Whole thread Raw
In response to Re: Set enable_seqscan doesn't take effect?  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
> 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.


pgsql-hackers by date:

Previous
From: "Hayato Kuroda (Fujitsu)"
Date:
Subject: RE: [PGdocs] fix description for handling pf non-ASCII characters
Next
From: jacktby jacktby
Date:
Subject: Re: Set enable_seqscan doesn't take effect?