Request a Demo
Home   >   mailing lists

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

From David Rowley
Subject Re: Optional skipping of unchanged relations during ANALYZE?
Date
Msg-id CAApHDvqULEFpcaaRBnQt-bsCa5-+mAzDPgK3Qd6C_KXVEAFgBw@mail.gmail.com
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
Tree view 
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

pgsql-hackers by date:

Previous
From: lakshmi
Date:
Subject: Re: Proposal: Adding compression of temporary files
Next
From: John Naylor
Date:
Subject: Re: tuple radix sort