Request a Demo
Home   >   mailing lists

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

From Yugo Nagata
Subject Re: Doc: Add note for running ANALYZE after ALTER TABLE ... SET EXPRESSION
Date
Msg-id 20250806154358.b6d0958260776432f6cd4d20@sraoss.co.jp
Whole thread Raw
In response to Re: Doc: Add note for running ANALYZE after ALTER TABLE ... SET EXPRESSION  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: Doc: Add note for running ANALYZE after ALTER TABLE ... SET EXPRESSION
List pgsql-hackers
Tree view 
On Wed, 6 Aug 2025 13:20:18 +0900
Fujii Masao <masao.fujii@gmail.com> wrote:

> 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?

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@sraoss.co.jp>
Attachment

pgsql-hackers by date:

Previous
From: shveta malik
Date:
Subject: Re: POC: enable logical decoding when wal_level = 'replica' without a server restart
Next
From: Fujii Masao
Date:
Subject: Re: Doc: Add note for running ANALYZE after ALTER TABLE ... SET EXPRESSION