Horton

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

Nathan Bossart <nathandbossart@gmail.com>

View thread View on postgr.es
From: Nathan Bossart <nathandbossart@gmail.com>
To: Yugo Nagata <nagata@sraoss.co.jp>
Cc: Fujii Masao <masao.fujii@gmail.com>, Pgsql Hackers <pgsql-hackers@postgresql.org>
Date: 2025-08-20T19:19:43Z
Lists: pgsql-hackers 
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.

-- 
nathan

Commits

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