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

Nathan Bossart <nathandbossart@gmail.com>

From: Nathan Bossart <nathandbossart@gmail.com>
To: Fujii Masao <masao.fujii@gmail.com>
Cc: Yugo Nagata <nagata@sraoss.co.jp>, Pgsql Hackers <pgsql-hackers@postgresql.org>
Date: 2025-08-21T13:56:48Z
Lists: pgsql-hackers

Attachments

On Thu, Aug 21, 2025 at 11:13:44AM +0900, Fujii Masao wrote:
> On Thu, Aug 21, 2025 at 4:19 AM Nathan Bossart <nathandbossart@gmail.com> wrote:
>> 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

Since we're running out of time for v18, I went ahead and updated the
patch.  I've also added an open item for this.

-- 
nathan

Commits

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