Re: Optional skipping of unchanged relations during ANALYZE?

Thanks for pointing that out.

On Tue, Jan 20, 2026 at 4:16 PM Christoph Berg <myon(at)debian(dot)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