Re: Optional skipping of unchanged relations during ANALYZE?

On Wed, 21 Jan 2026 at 00:02, VASUKI M <vasukianand0119@gmail.com> wrote:
> On Tue, Jan 20, 2026 at 4:16 PM Christoph Berg <myon@debian.org> wrote:
>> 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.

If doing this, you would also need to make special consideration for
partitioned tables, as n_mod_since_analyze won't change for those
directly, but it might have changed for their partitions.

David