Horton

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

Fujii Masao <masao.fujii@gmail.com>

View thread View on postgr.es
From: Fujii Masao <masao.fujii@gmail.com>
To: Nathan Bossart <nathandbossart@gmail.com>
Cc: Yugo Nagata <nagata@sraoss.co.jp>, Pgsql Hackers <pgsql-hackers@postgresql.org>
Date: 2025-08-21T02:13:44Z
Lists: pgsql-hackers 
On Thu, Aug 21, 2025 at 4:19 AM Nathan Bossart <nathandbossart@gmail.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

Commits

  1. vacuumdb: Fix --missing-stats-only with virtual generated columns.