Re: Doc: Add note for running ANALYZE after ALTER TABLE ... SET EXPRESSION

2025-08-06 Thread Fujii Masao
On Wed, Aug 6, 2025 at 3:44 PM Yugo Nagata wrote: > Yes. I believe the back-patching would be better to both v17 and v18. > I've attached a patch for v17. Thanks for the patch for v17! I've pushed the patches. Regards, -- Fujii Masao

Re: Doc: Add note for running ANALYZE after ALTER TABLE ... SET EXPRESSION

2025-08-05 Thread Yugo Nagata
On Wed, 6 Aug 2025 13:20:18 +0900 Fujii Masao wrote: > On Tue, Aug 5, 2025 at 10:09 AM Yugo Nagata wrote: > > Thank you for looking at it. I overlooked that virtual generated columns > > don't have statistics currently (I'm working on this at [1], though). > > > > Your suggestion makes sense, so

Re: Doc: Add note for running ANALYZE after ALTER TABLE ... SET EXPRESSION

2025-08-05 Thread Fujii Masao
On Tue, Aug 5, 2025 at 10:09 AM Yugo Nagata wrote: > Thank you for looking at it. I overlooked that virtual generated columns > don't have statistics currently (I'm working on this at [1], though). > > Your suggestion makes sense, so I've attached an updated patch. > I also mentioned virtual gener

Re: Doc: Add note for running ANALYZE after ALTER TABLE ... SET EXPRESSION

2025-08-04 Thread Yugo Nagata
On Mon, 4 Aug 2025 20:01:34 +0900 Fujii Masao wrote: > On Mon, Aug 4, 2025 at 3:14 PM Yugo Nagata wrote: > > > > Hi, > > > > The documentation recommends running ANALYZE after the "ALTER TABLE ... SET > > DATA TYPE" > > command since the statistics will become wrong after that. > > > > That sam

Re: Doc: Add note for running ANALYZE after ALTER TABLE ... SET EXPRESSION

2025-08-04 Thread Fujii Masao
On Mon, Aug 4, 2025 at 3:14 PM Yugo Nagata wrote: > > Hi, > > The documentation recommends running ANALYZE after the "ALTER TABLE ... SET > DATA TYPE" > command since the statistics will become wrong after that. > > That same thing can be applied to "ALTER TABLE ... SET EXPRESSION" commands, > bu

Doc: Add note for running ANALYZE after ALTER TABLE ... SET EXPRESSION

2025-08-03 Thread Yugo Nagata
Hi, The documentation recommends running ANALYZE after the "ALTER TABLE ... SET DATA TYPE" command since the statistics will become wrong after that. That same thing can be applied to "ALTER TABLE ... SET EXPRESSION" commands, but that is not described in the documentation, so I've attached a pa