Re: Optional skipping of unchanged relations during ANALYZE?

From: Christoph Berg <myon(at)debian(dot)org>
To: VASUKI M <vasukianand0119(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Optional skipping of unchanged relations during ANALYZE?
Date: 2026-01-20 10:46:25
Message-ID: aW9dAW0GiLbMs6L9@msg.df7cb.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Christoph

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Geier 2026-01-20 10:48:00 Re: Change copyObject() to use typeof_unqual
Previous Message shveta malik 2026-01-20 10:38:33 Re: Proposal: Conflict log history table for Logical Replication