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 ) id 1n09o7-0003Jp-MT for pgsql-docs@arkaria.postgresql.org; Wed, 22 Dec 2021 22:09:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n09o6-0000n4-IC for pgsql-docs@arkaria.postgresql.org; Wed, 22 Dec 2021 22:09:58 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n09o6-0000mp-B5 for pgsql-docs@lists.postgresql.org; Wed, 22 Dec 2021 22:09:58 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n09o3-0005Qc-NK for pgsql-docs@lists.postgresql.org; Wed, 22 Dec 2021 22:09:57 +0000 Received: from bruce by momjian.us with local (Exim 4.92) (envelope-from ) id 1n09o1-0003v2-RP; Wed, 22 Dec 2021 17:09:53 -0500 Date: Wed, 22 Dec 2021 17:09:53 -0500 From: Bruce Momjian To: "David G. Johnston" Cc: Chris Lowder , Pg Docs Subject: Re: 11.7. Indexes on Expressions Message-ID: <20211222220953.GC4015@momjian.us> References: <20211216205232.GA30462@momjian.us> <20211217214343.GC5592@momjian.us> <20211222214558.GB4015@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Dec 22, 2021 at 03:06:12PM -0700, David G. Johnston wrote: > On Wed, Dec 22, 2021 at 2:45 PM Bruce Momjian wrote: > Not sure what else we can do --- it would be odd to explain it in the > expression index docs. > > > > Found another one: > > https://www.postgresql.org/docs/current/btree-implementation.html > "...(where most individual updates cannot apply the HOT optimization." > > Make the acronym HOT in all these places take the reader to the acronym page, > and add a brief description there so they don't need to consume the readme > file? Wow, I don't think the acronym page is the right place for this --- I think we need a new section for this somewhere. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.