Date: Wed, 22 Dec 2021 16:45:58 -0500
From: Bruce Momjian <bruce@momjian.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Chris Lowder <clowder@hey.com>,
	Pg Docs <pgsql-docs@lists.postgresql.org>
Subject: Re: 11.7. Indexes on Expressions
Message-ID: <20211222214558.GB4015@momjian.us>
References: <20211216205232.GA30462@momjian.us>
 <b4093b5a1383fe157e7dfd52606f4173352fd4fb@hey.com>
 <20211217214343.GC5592@momjian.us>
 <CAKFQuwZkCzDLjHJKydOMEij0Ysx1E+rVPt_7Z3+Cpse+tYsd9w@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CAKFQuwZkCzDLjHJKydOMEij0Ysx1E+rVPt_7Z3+Cpse+tYsd9w@mail.gmail.com>
User-Agent: Mutt/1.10.1 (2018-07-13)
Archived-At: 
 <https://www.postgresql.org/message-id/20211222214558.GB4015%40momjian.us>
Precedence: bulk

On Wed, Dec 22, 2021 at 02:40:12PM -0700, David G. Johnston wrote:
> On Fri, Dec 17, 2021 at 2:43 PM Bruce Momjian <bruce@momjian.us> wrote:
> 
>     I am attaching an updated patch which mentions non-HOT updates for
>     expression indexes.
> 
> 
> Thanks.  I'm a bit concerned that before this patch the only place we mentioned
> HOTin the docs is in the appendix acronym listing which points to the readme
> file in the source code.

Uh, I had a similar concern and found these cases:

	monitoring.sgml:       Number of rows updated (includes HOT updated rows)
	monitoring.sgml:       Number of rows HOT updated (i.e., with no separate index

Not sure what else we can do --- it would be odd to explain it in the
expression index docs.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.