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
-
vacuumdb: Fix --missing-stats-only with virtual generated columns.
- b63952a78113 19 (unreleased) landed
- 8c0c86863744 18.0 landed