Re: Don't treat virtual generated columns as missing statistics in vacuumdb --missing-stats-only

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Nathan Bossart <nathandbossart(at)gmail(dot)com>
Cc: Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Don't treat virtual generated columns as missing statistics in vacuumdb --missing-stats-only
Date: 2025-08-21 02:13:44
Message-ID: CAHGQGwEOm2jEEL7xxa6Kk4_eGsK_8fPgnZteoGO=FkDzNqtuoQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Aug 21, 2025 at 4:19 AM Nathan Bossart <nathandbossart(at)gmail(dot)com> wrote:
>
> On Wed, Aug 20, 2025 at 01:53:38PM +0900, Yugo Nagata wrote:
> > The patch conflicted with the latest commit, so I rebased it.
>
> Nice find. I would suggest adding the virtual generated column to
> regression_vacuumdb_test when it is first created so that we can just rely
> on the existing test cases. In fact, by doing so, you'll see that we need
> a similar change to the "inheritance and regular stats" part of the query.

+1

Regards,

--
Fujii Masao

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Chao Li 2025-08-21 02:15:14 Re: Remove redundant assignment of a variable in function AlterPublicationTables
Previous Message Andrey Borodin 2025-08-21 02:07:16 Re: VM corruption on standby