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

From: Nathan Bossart <nathandbossart(at)gmail(dot)com>
To: Baji Shaik <baji(dot)pgdev(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Fix --missing-stats-only false positive for partitioned expression indexes
Date: 2026-06-16 16:14:10
Message-ID: ajF2UpggfQ_WPJ95@nathan
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jun 16, 2026 at 10:25:52AM -0500, Baji Shaik wrote:
> I tested "vacuumdb --missing-stats-only" and found that it flags
> partitioned tables that have expression indexes, even after a full
> ANALYZE.

Thanks for reporting.

- " OR EXISTS (SELECT NULL FROM pg_catalog.pg_attribute a\n"
+ " OR (NOT p.inherited"
+ " AND EXISTS (SELECT NULL FROM pg_catalog.pg_attribute a\n"

I'm curious why you added this check to the beginning and surrounded the
rest with parentheses. Wouldn't it be better to follow the example of the
surrounding clauses and an "AND NOT p.inherited" somewhere in the middle?

--
nathan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2026-06-16 16:14:25 Re: Improving the names generated for indexes on expressions
Previous Message Jacob Champion 2026-06-16 16:11:32 Re: Direction for test frameworks: Perl TAP vs. Python/pytest