Re: 11.7. Indexes on Expressions

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Chris Lowder <clowder(at)hey(dot)com>, Pg Docs <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: 11.7. Indexes on Expressions
Date: 2021-12-22 21:45:58
Message-ID: 20211222214558.GB4015@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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(at)momjian(dot)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(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

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

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2021-12-22 22:06:12 Re: 11.7. Indexes on Expressions
Previous Message Euler Taveira 2021-12-22 21:42:33 Re: include_dir - 'if_exists' logic yes or no?