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

On Wed, 6 Aug 2025 13:20:18 +0900
Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:

> On Tue, Aug 5, 2025 at 10:09 AM Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp> 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 generated column in the description
> > of SET DATA TYPE.

> Thanks for updating the patch!
>
> As for back-patching, ANALYZE recommendation for SET EXPRESSION should
> be back-patched to v17, where that feature was introduced? Similarly,
> the note about virtual generated columns should go into v18,
> since that's when they were added?

Yes. I believe the back-patching would be better to both v17 and v18.
I've attached a patch for v17.

Regards,
Yugo Nagata

--
Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>