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

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>
Cc: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Doc: Add note for running ANALYZE after ALTER TABLE ... SET EXPRESSION
Date: 2025-08-06 04:20:18
Message-ID: CAHGQGwFdCbinO0AYUaFxubrKWex06fVde1jF5CXP3V+qJM4i-w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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?

Regards,

--
Fujii Masao

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Sami Imseih 2025-08-06 04:24:04 Re: Improve LWLock tranche name visibility across backends
Previous Message Chao Li 2025-08-06 04:17:24 Re: Fixed a minor typo in code comment