Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1viUlh-007vft-0I
	for pgsql-hackers@arkaria.postgresql.org;
	Wed, 21 Jan 2026 09:44:53 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1viUlf-006FPs-2I
	for pgsql-hackers@arkaria.postgresql.org;
	Wed, 21 Jan 2026 09:44:52 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <cb@df7cb.de>)
	id 1viUlf-006FPk-1K
	for pgsql-hackers@lists.postgresql.org;
	Wed, 21 Jan 2026 09:44:51 +0000
Received: from goedel.df7cb.de ([49.13.90.212])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <cb@df7cb.de>)
	id 1viUlc-001ZUW-0y
	for pgsql-hackers@lists.postgresql.org;
	Wed, 21 Jan 2026 09:44:50 +0000
Received: from msg.df7cb.de (unknown [IPv6:2a02:908:1472:9340:f0ad:fc6e:9c86:f1dc])
	by goedel.df7cb.de (Postfix) with ESMTPSA id 28F09B757;
	Wed, 21 Jan 2026 09:44:46 +0000 (UTC)
Date: Wed, 21 Jan 2026 10:44:45 +0100
From: Christoph Berg <myon@debian.org>
To: VASUKI M <vasukianand0119@gmail.com>
Cc: Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>,
	Robert Haas <robertmhaas@gmail.com>,
	David Rowley <dgrowleyml@gmail.com>, Robert Treat <rob@xzilla.net>
Subject: Re: Optional skipping of unchanged relations during ANALYZE?
Message-ID: <aXCgDaz9y2ssA84N@msg.df7cb.de>
References: <CAE2r8H7+eACA+QxisuPY1jveA=YLuH7CE8F3TedmZfsKdYxOeA@mail.gmail.com>
 <CABV9wwNYQ6V4-kKzPbJ0fGtgrq_+0z1kLiWQ8yqqDL-hEmphdQ@mail.gmail.com>
 <CAE2r8H7jVmsLaWi19ZuxmwR-8UjtN6Ejv7YmtDrPinCYtE8cUA@mail.gmail.com>
 <c57f96fc-e3de-4690-a4c7-bda6af16aa58@tantorlabs.com>
 <CAE2r8H5Gsfs4REdo=Phj2GUv18Q5fsy-CBq0jbXyjrK1V-P5ag@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <CAE2r8H5Gsfs4REdo=Phj2GUv18Q5fsy-CBq0jbXyjrK1V-P5ag@mail.gmail.com>
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: <https://www.postgresql.org/message-id/aXCgDaz9y2ssA84N%40msg.df7cb.de>
Precedence: bulk

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