Re: Set enable_seqscan doesn't take effect?

2023-09-28 Thread Bruce Momjian
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

Re: Set enable_seqscan doesn't take effect?

2023-09-28 Thread jacktby jacktby
> 2023年9月28日 12:26，David G. Johnston 写道： > > On Wednesday, September 27, 2023, jacktby jacktby > wrote: >> postgres=# SET enable_seqscan = off; >> SET >> postgres=# explain select * from t; >>QUERY PLAN

Re: Set enable_seqscan doesn't take effect?

2023-09-28 Thread jacktby jacktby
> 2023年9月28日 01:07，Andres Freund 写道： > > 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 >>

Re: Set enable_seqscan doesn't take effect?

2023-09-27 Thread David G. Johnston
On Wednesday, September 27, 2023, jacktby jacktby wrote: > postgres=# SET enable_seqscan = off; > SET > postgres=# explain select * from t; >QUERY PLAN > - > Seq Scan on t

Re: Set enable_seqscan doesn't take effect?

2023-09-27 Thread jacktby jacktby
> 2023年9月28日 01:07，Andres Freund 写道： > > 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 >>

Re: Set enable_seqscan doesn't take effect?

2023-09-27 Thread jacktby jacktby
> 2023年9月28日 01:07，Andres Freund 写道： > > 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 >>

Re: Set enable_seqscan doesn't take effect?

2023-09-27 Thread David Rowley
On Thu, 28 Sept 2023 at 13:47, jacktby jacktby wrote: > > postgres=# SET enable_seqscan = off; > SET > postgres=# explain select * from t; >QUERY PLAN > - > Seq Scan on t

Re: Set enable_seqscan doesn't take effect?

2023-09-27 Thread Andres Freund
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 > - >

Set enable_seqscan doesn't take effect?

2023-09-27 Thread jacktby jacktby
postgres=# SET enable_seqscan = off; SET postgres=# explain select * from t; QUERY PLAN - Seq Scan on t (cost=100.00..123.60 rows=1360 width=32)