Re: Fix --missing-stats-only false positive for partitioned expression indexes

Nathan Bossart <nathandbossart@gmail.com>

From: Nathan Bossart <nathandbossart@gmail.com>
To: Corey Huinker <corey.huinker@gmail.com>
Cc: Baji Shaik <baji.pgdev@gmail.com>, PostgreSQL-development <pgsql-hackers@lists.postgresql.org>
Date: 2026-06-16T16:46:40Z
Lists: pgsql-hackers
On Tue, Jun 16, 2026 at 12:40:11PM -0400, Corey Huinker wrote:
> On Tue, Jun 16, 2026 at 12:26 PM Baji Shaik <baji.pgdev@gmail.com> wrote:
>> Good point. v2 moves the check inside the EXISTS as
>> "AND NOT p.inherited", consistent with how the inheritance
>> sections below handle it.
> 
> The refactor I was testing differed only in having the new qual one line
> higher (above the attstattarget check vs below it). Looks good to me.

We could remove the final "AND s.stainherit = p.inherited" in this part of
the clause, too, right?

-- 
nathan



Commits

  1. vacuumdb: Fix --missing-stats-only for partitioned indexes.