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 EF8D340A-FD45-440F-BE7D-BC7640115DF8@gmail.com
Whole thread Raw
In response to Re: Set enable_seqscan doesn't take effect?  (Andres Freund <andres@anarazel.de>)
Responses Re: Set enable_seqscan doesn't take effect?
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: Amit Kapila
Date:
Subject: Re: [PoC] pg_upgrade: allow to upgrade publisher node
Next
From: jacktby jacktby
Date:
Subject: Re: Set enable_seqscan doesn't take effect?