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

From VASUKI M
Subject Re: Optional skipping of unchanged relations during ANALYZE?
Date
Msg-id CAE2r8H7Fs-KyAEXH0j9MKW_5axFAkuhWC0htM0k03-Zw0TV9fQ@mail.gmail.com
Whole thread Raw
In response to Re: Optional skipping of unchanged relations during ANALYZE?  (Christoph Berg <myon@debian.org>)
Responses Re: Optional skipping of unchanged relations during ANALYZE?
List pgsql-hackers
Thanks for pointing that out.

On Tue, Jan 20, 2026 at 4:16 PM Christoph Berg <myon@debian.org> wrote:
Re: VASUKI M
> I’m considering working on an optional mode where ANALYZE would skip
> relations that have not been modified since their last analyze, based
> on existing pg_stat counters (for example, mod_since_analyze = 0).

Make sure that doesn't skip tables that were never analyzed before.


Yes, the intention is that SMART ANALYZE would not skip relations that have never been analyzed before.
The skip decision is based on pg_stat entries, so relations without existing statistics will still be analyzed normally.

I’ll make sure this behavior is clear and covered when I post the patch.

Thanks,
Vasuki M
C-DAC,Chennai 

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Logical Replication of sequences
Next
From: Soumya S Murali
Date:
Subject: Re: Allowing ALTER COLUMN TYPE for columns in publication column lists