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

From: Nathan Bossart <nathandbossart(at)gmail(dot)com>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>, Corey Huinker <corey(dot)huinker(at)gmail(dot)com>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Don't treat virtual generated columns as missing statistics in vacuumdb --missing-stats-only
Date: 2025-08-22 14:05:56
Message-ID: aKh5RBbtlU3I3jde@nathan
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message myzhen 2025-08-22 14:08:52 Re:Re: Improve cache hit rate for OprCacheHash
Previous Message Richard Guo 2025-08-22 14:01:41 Re: Remove unneeded cast in heap_xlog_lock.