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 1viSwM-0074rA-0W
	for pgsql-hackers@arkaria.postgresql.org;
	Wed, 21 Jan 2026 07:47:46 +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 1viSwK-005WdR-29
	for pgsql-hackers@arkaria.postgresql.org;
	Wed, 21 Jan 2026 07:47:45 +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 <ilya.evdokimov@tantorlabs.com>)
	id 1viSwK-005WdJ-19
	for pgsql-hackers@lists.postgresql.org;
	Wed, 21 Jan 2026 07:47:44 +0000
Received: from forward502b.mail.yandex.net ([178.154.239.146])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <ilya.evdokimov@tantorlabs.com>)
	id 1viSwG-001YVz-1N
	for pgsql-hackers@lists.postgresql.org;
	Wed, 21 Jan 2026 07:47:43 +0000
Received: from mail-nwsmtp-smtp-production-main-70.sas.yp-c.yandex.net (mail-nwsmtp-smtp-production-main-70.sas.yp-c.yandex.net [IPv6:2a02:6b8:c23:21b4:0:640:bc6c:0])
	by forward502b.mail.yandex.net (Yandex) with ESMTPS id 4EE0C899C1;
	Wed, 21 Jan 2026 10:47:37 +0300 (MSK)
Received: by mail-nwsmtp-smtp-production-main-70.sas.yp-c.yandex.net (smtp/Yandex) with ESMTPSA id YlV1rg3G7eA0-IEpdBd57;
	Wed, 21 Jan 2026 10:47:36 +0300
X-Yandex-Fwd: 1
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=tantorlabs.com;
	s=mail; t=1768981656;
	bh=4LrKXnJ189KZ1eYzPzwPR/FGdCHi6erO3O7lOdJ6LQA=;
	h=From:In-Reply-To:Cc:Date:References:To:Subject:Message-ID;
	b=uzuEtTtb/br7Fb09gyedUz1z8hU5/7K6snkmF3RPDLdWNGhSquYFqxaNEiAvTvuZm
	 wJ/PxY50V+VxSoDrqfmB92Jic/ljNZqbrqk+3zvtBwnag2LlY8owuDZVlhQlB3cQmj
	 L2ToT3vtFUJxM5Csa0OucRTdY+vICfCCLvUybMms=
Authentication-Results: mail-nwsmtp-smtp-production-main-70.sas.yp-c.yandex.net; dkim=pass header.i=@tantorlabs.com
Message-ID: <c57f96fc-e3de-4690-a4c7-bda6af16aa58@tantorlabs.com>
Date: Wed, 21 Jan 2026 10:47:33 +0300
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Optional skipping of unchanged relations during ANALYZE?
To: VASUKI M <vasukianand0119@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>,
 Christoph Berg <myon@debian.org>, Robert Haas <robertmhaas@gmail.com>,
 David Rowley <dgrowleyml@gmail.com>, Robert Treat <rob@xzilla.net>
References: <CAE2r8H7+eACA+QxisuPY1jveA=YLuH7CE8F3TedmZfsKdYxOeA@mail.gmail.com>
 <CABV9wwNYQ6V4-kKzPbJ0fGtgrq_+0z1kLiWQ8yqqDL-hEmphdQ@mail.gmail.com>
 <CAE2r8H7jVmsLaWi19ZuxmwR-8UjtN6Ejv7YmtDrPinCYtE8cUA@mail.gmail.com>
Content-Language: en-US
From: Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>
In-Reply-To: <CAE2r8H7jVmsLaWi19ZuxmwR-8UjtN6Ejv7YmtDrPinCYtE8cUA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
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/c57f96fc-e3de-4690-a4c7-bda6af16aa58%40tantorlabs.com>
Precedence: bulk

Another concern with skipping ANALYZE on unchanged tables is extended 
statistics.

If CREATE/ALTER STATISTICS is executed, it would still be desirable for 
ANALYZE to collect the newly statistics and extended ones, even if the 
table data itself has not changed.

What do you think about this?

-- 
Best regards,
Ilia Evdokimov,
Tantor Labs LLC,
https://tantorlabs.com/