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

From Robert Treat
Subject Re: Optional skipping of unchanged relations during ANALYZE?
Date
Msg-id CAJSLCQ2ZTLng_4vF9O74oxaOg_cAxD6=ixLMoW_+5CxCkNtXrA@mail.gmail.com
Whole thread Raw
In response to Re: Optional skipping of unchanged relations during ANALYZE?  (Christoph Berg <myon@debian.org>)
List pgsql-hackers
On Wed, Jan 21, 2026 at 4:44 AM Christoph Berg <myon@debian.org> wrote:
>
> Re: VASUKI M
> >     VACUUM(SMART);
>
> IMHO it was a historical mistake to combine VACUUM and ANALYZE into a
> single command. We should not add any more options on that
> combination. If people want to pass options to ANALYZE, they should
> call ANALYZE and not VACUUM.
>

I don't know if I go that far, but if you are saying that you dont
think "smart analyze" should be an option for vacuum runs, I can get
onboard with that. We don't really know what any given vacuum run will
do with regards to the table, but if we are shuffling data / storage
around, it probably makes sense to update statistics info along the
way.

Robert Treat
https://xzilla.net



pgsql-hackers by date:

Previous
From: Joao Foltran
Date:
Subject: Re: [BUG] [PATCH] Allow physical replication slots to recover from archive after invalidation
Next
From: Andres Freund
Date:
Subject: Re: warning: dereferencing type-punned pointer