Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1kefyL-0004PP-Pe
	for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Nov 2020 14:59:13 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1kefyJ-0003zx-B2
	for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Nov 2020 14:59:11 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <alvherre@alvh.no-ip.org>)
	id 1kefyJ-0003yl-3y
	for pgsql-hackers@lists.postgresql.org; Mon, 16 Nov 2020 14:59:11 +0000
Received: from wout4-smtp.messagingengine.com ([64.147.123.20])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <alvherre@alvh.no-ip.org>)
	id 1kefyH-0003A4-5o
	for pgsql-hackers@lists.postgresql.org; Mon, 16 Nov 2020 14:59:10 +0000
Received: from compute2.internal (compute2.nyi.internal [10.202.2.42])
	by mailout.west.internal (Postfix) with ESMTP id 50FA6A4E;
	Mon, 16 Nov 2020 09:59:07 -0500 (EST)
Received: from mailfrontend1 ([10.202.2.162])
  by compute2.internal (MEProxy); Mon, 16 Nov 2020 09:59:07 -0500
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:content-type:date:from:in-reply-to
	:message-id:mime-version:subject:to:x-me-proxy:x-me-proxy
	:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=0wk5FjW/YJOt4EfyT
	tJacdwcouU/dTf0DB2ksH/A/j4=; b=abm26SmnyKwyWvmTsXQ+QIyBiRBQEkpjG
	BjNSDmxYeRiIPeVWfSm1/MGGJN2B0L6S/KOFNAxXQR2Lx6FXLnfhpgzX9kIAhy8s
	4oxcCKi5T3ky/6CjAVwSh7oM/kqkFtanymMoIPCl3KKBf3fydvNtEm6yZOqzMRcZ
	Gne7Tc4AUyWkUY2Temq6N51Vf9jRzwZRBYrcV4bzwfCAjEhfds0eSbvAKITXhtAB
	whFX9XQPOVjahJYK00G5FC/m30CKIbXv2YbFWxF0PNLckQoAsjdVWY+G0WebDukI
	RLg+V+YNHeS/phx6AOpD+jA4OMJv2gSfSVxBZVQcWJm6WDEpEsQ4g==
X-ME-Sender: <xms:upOyXwqf-i4Iw3y5K_OvYpyuTbJZBNK8UPwRZM6gR2q4pSjjDZNNWQ>
    <xme:upOyX2rPxrxgmpGjNAn01az7TTfVoxORQmo50ik4jtFZ_CeTwDbRf2L23DM7xLy27
    gxYIfkRJhZIdZdv9Q>
X-ME-Proxy-Cause: 
 gggruggvucftvghtrhhoucdtuddrgedujedrudefuddgjedvucetufdoteggodetrfdotf
    fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen
    uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne
    cujfgurhepfffhvffukfggtggujggfsehttdertddtredvnecuhfhrohhmpeetlhhvrghr
    ohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgqe
    enucggtffrrghtthgvrhhnpeevgfelveegueejgefhgeetgefhgeehieefheehleetteei
    udeiiefhgffgheffteenucfkphepudeltddrleehrddukedrjeelnecuvehluhhsthgvrh
    fuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhhvghrrhgvsegrlhhv
    hhdrnhhoqdhiphdrohhrgh
X-ME-Proxy: <xmx:upOyX1PkFxi8_xLDHd2BZWCjTBB7oyL9_6C1RQxlQ_ZP_N8VU0chLg>
    <xmx:upOyX341tnQhUsfRphrSlbiUq2OPBk7W43ySJC_UMxezDj_rF9YgXw>
    <xmx:upOyX_6-Dzat290nnt0Ck7ZvFyN1J8_Q2_LJJukIDe92Wbvb0ZyC4A>
    <xmx:upOyX5QyQ0-T7wxmXPMriZY4WS3aGuA02M9gr9IaSnRtJpq5DbCCdA>
Received: from perhan.alvh.no-ip.org (unknown [190.95.18.79])
	by mail.messagingengine.com (Postfix) with ESMTPA id 1B98A3280060;
	Mon, 16 Nov 2020 09:59:06 -0500 (EST)
Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000)
	id 7F4862A1561; Mon, 16 Nov 2020 11:59:03 -0300 (-03)
Date: Mon, 16 Nov 2020 11:59:03 -0300
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Bruce Momjian <bruce@momjian.us>
Cc: Justin Pryzby <pryzby@telsasoft.com>,
	Nikolay Samokhvalov <samokhvalov@gmail.com>,
	fabriziomello@gmail.com, pgsql-hackers@lists.postgresql.org
Subject: Re: Add important info about ANALYZE after create Functional Index
Message-ID: <20201116145903.GA20503@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20201112230102.GE4506@momjian.us>
User-Agent: Mutt/1.10.1 (2018-07-13)
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>
Precedence: bulk

On 2020-Nov-12, Bruce Momjian wrote:

>     For new expression indexes, it is necessary to run <link
>     linkend="sql-analyze"><command>ANALYZE</command></link> or wait for
>     the <link linkend="autovacuum">autovacuum daemon</link> to analyze
> -   the table to generate statistics about new expression indexes.
> +   the table to generate statistics for these indexes.

Looks good to me.