Request a Demo
Home   >   mailing lists

Re: Doc: Add note for running ANALYZE after ALTER TABLE ... SET EXPRESSION - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: Doc: Add note for running ANALYZE after ALTER TABLE ... SET EXPRESSION
Date
Msg-id CAHGQGwFdCbinO0AYUaFxubrKWex06fVde1jF5CXP3V+qJM4i-w@mail.gmail.com
Whole thread Raw
In response to Re: Doc: Add note for running ANALYZE after ALTER TABLE ... SET EXPRESSION  (Yugo Nagata <nagata@sraoss.co.jp>)
Responses Re: Doc: Add note for running ANALYZE after ALTER TABLE ... SET EXPRESSION
List pgsql-hackers
Tree view 
On Tue, Aug 5, 2025 at 10:09 AM Yugo Nagata <nagata@sraoss.co.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?

Regards,

--
Fujii Masao

pgsql-hackers by date:

Previous
From: Chao Li
Date:
Subject: Re: Fixed a minor typo in code comment
Next
From: Sami Imseih
Date:
Subject: Re: Improve LWLock tranche name visibility across backends