Re: Optional skipping of unchanged relations during ANALYZE?

From: VASUKI M <vasukianand0119(at)gmail(dot)com>
To: Christoph Berg <myon(at)debian(dot)org>
Cc: Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>, Robert Treat <rob(at)xzilla(dot)net>
Subject: Re: Optional skipping of unchanged relations during ANALYZE?
Date: 2026-01-21 09:47:44
Message-ID: CAE2r8H5SpHmfHQXmv9QMfKAMdw=F3fq0MLbLvGxH670GhwQt0w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Sorry,forgot to mention that it will produce error as 'SMART requires
ANALYZE'

It's just a checking command :)

-Vasu

On Wed, Jan 21, 2026 at 3:14 PM Christoph Berg <myon(at)debian(dot)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.
>
> Christoph
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christoph Berg 2026-01-21 09:50:59 Re: Optional skipping of unchanged relations during ANALYZE?
Previous Message Christoph Berg 2026-01-21 09:44:45 Re: Optional skipping of unchanged relations during ANALYZE?