Re: Optional skipping of unchanged relations during ANALYZE? - Mailing list pgsql-hackers

From Andreas Karlsson
Subject Re: Optional skipping of unchanged relations during ANALYZE?
Date
Msg-id be509f90-74bd-4a81-83a7-d5afa0d17b38@proxel.se
Whole thread Raw
In response to Re: Optional skipping of unchanged relations during ANALYZE?  (VASUKI M <vasukianand0119@gmail.com>)
Responses Re: Optional skipping of unchanged relations during ANALYZE?
List pgsql-hackers
On 2/13/26 1:14 PM, VASUKI M wrote:
> As discussed earlier in the thread, I plan to start a new discussion and 
> patch series for a separate ANALYZE (MODIFIED_STATS) option that would 
> reuse autoanalyze-style thresholds. I believe keeping MISSING_STATS_ONLY 
> and MODIFIED_STATS as separate, clearly defined options makes the 
> semantics easier to reason about.

When would a user ever want MODIFIED_STATS without also analyzing tables 
without any stats? I had more thought of calling it something like 
SKIP_UNMODIFIED but maybe there is a case for MISSING_STATS_ONLY, 
especially since the command line tool supports it.

Andreas




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: AIX support
Next
From: Lukas Fittl
Date:
Subject: Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?