Re: Proposal: ANALYZE (MODIFIED_STATS) using autoanalyze thresholds - Mailing list pgsql-hackers

From Nathan Bossart
Subject Re: Proposal: ANALYZE (MODIFIED_STATS) using autoanalyze thresholds
Date
Msg-id aZSm77WEh8pxQYtf@nathan
Whole thread Raw
In response to Proposal: ANALYZE (MODIFIED_STATS) using autoanalyze thresholds  (VASUKI M <vasukianand0119@gmail.com>)
Responses Re: Proposal: ANALYZE (MODIFIED_STATS) using autoanalyze thresholds
List pgsql-hackers
On Tue, Feb 17, 2026 at 04:12:58PM +0530, VASUKI M wrote:
> I would greatly appreciate thoughts before working on a prototype patch.

At the risk of substantially expanding the scope of these patches, I wonder
if a better long-term approach would be to first centralize the
autovacuum/autoanalyze prioritization code and share it via a system view
that vacuumdb could use in place of the giant query for
--missing-stats-only.  That would also give users visibility into
auto{vacuum,analyze}'s decisions.  TBH I'm not totally sold on the idea of
giving ANALYZE more options for this stuff, if for no other reason than I'm
not really following the concrete use-cases, but I wouldn't say I'm
mortally opposed to it.

-- 
nathan



pgsql-hackers by date:

Previous
From: Álvaro Herrera
Date:
Subject: Re: [WIP]Vertical Clustered Index (columnar store extension) - take2
Next
From: Álvaro Herrera
Date:
Subject: Re: Headerscheck support for meson