pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bruce Momjian <bruce@momjian.us>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: Chris Lowder <clowder@hey.com>
Cc: Pg Docs <pgsql-docs@lists.postgresql.org>
Subject: Re: 11.7. Indexes on Expressions
Date: Wed, 22 Dec 2021 16:45:58 -0500
Message-ID: <20211222214558.GB4015@momjian.us> (raw)
In-Reply-To: <CAKFQuwZkCzDLjHJKydOMEij0Ysx1E+rVPt_7Z3+Cpse+tYsd9w@mail.gmail.com>
References: <20211216205232.GA30462@momjian.us>
	<b4093b5a1383fe157e7dfd52606f4173352fd4fb@hey.com>
	<20211217214343.GC5592@momjian.us>
	<CAKFQuwZkCzDLjHJKydOMEij0Ysx1E+rVPt_7Z3+Cpse+tYsd9w@mail.gmail.com>

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.






view thread (14+ messages)  latest in thread

Message-ID: <20211222214558.GB4015@momjian.us>
Permalink:  ../20211222214558.GB4015@momjian.us/
Also on:    postgresql.org/message-id/20211222214558.GB4015@momjian.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: bruce@momjian.us, david.g.johnston@gmail.com, clowder@hey.com, pgsql-docs@lists.postgresql.org
  Subject: Re: 11.7. Indexes on Expressions
  In-Reply-To: <20211222214558.GB4015@momjian.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox