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: Fujii Masao <masao.fujii@gmail.com>
Cc: Yugo Nagata <nagata@sraoss.co.jp>, Corey Huinker <corey.huinker@gmail.com>, Pgsql Hackers <pgsql-hackers@postgresql.org>
Date: 2025-08-22T14:05:56Z
Lists: pgsql-hackers 
On Fri, Aug 22, 2025 at 10:19:32AM +0900, Fujii Masao wrote:
> At first, I just wondered whether vacuumdb --missing-stats-only would work
> on older servers, since the patch adds access to the attgenerated column,
> which might not exist there. But that's not an issue, because
> --missing-stats-only is supported only on servers version 15 or later,
> where attgenerated is available.

Yeah, this crossed my mind, too, and I reached the same conclusion.

-- 
nathan

Commits

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