Horton

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

Baji Shaik <baji.pgdev@gmail.com>

View thread View on postgr.es
From: Baji Shaik <baji.pgdev@gmail.com>
To: Nathan Bossart <nathandbossart@gmail.com>
Cc: Corey Huinker <corey.huinker@gmail.com>, PostgreSQL-development <pgsql-hackers@lists.postgresql.org>
Date: 2026-06-16T17:09:00Z
Lists: pgsql-hackers

Attachments

On Tue, Jun 16, 2026 at 11:46 AM Nathan Bossart <nathandbossart@gmail.com>
wrote:

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

Right. With NOT p.inherited already restricting this clause to the
non-inherited case, the stainherit filter is redundant since index stats
never have stainherit = true (only leaf indexes accumulate stats,
always with stainherit = false). I verified this holds across
partitioned, inherited, and mixed scenarios. Removed in v3.

v3 attached.

Thanks,
Baji Shaik.

Commits

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