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 17:13:17 -0500
Message-ID: <20211222221317.GD4015@momjian.us> (raw)
In-Reply-To: <20211222220953.GC4015@momjian.us>
References: <20211216205232.GA30462@momjian.us>
	<b4093b5a1383fe157e7dfd52606f4173352fd4fb@hey.com>
	<20211217214343.GC5592@momjian.us>
	<CAKFQuwZkCzDLjHJKydOMEij0Ysx1E+rVPt_7Z3+Cpse+tYsd9w@mail.gmail.com>
	<20211222214558.GB4015@momjian.us>
	<CAKFQuwZ_JgsW=hPi+asmaZqJ+kzi-mOCSC45RUbOZHQUCeJ_wg@mail.gmail.com>
	<20211222220953.GC4015@momjian.us>

On Wed, Dec 22, 2021 at 05:09:53PM -0500, Bruce Momjian wrote:
> 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 <bruce@momjian.us> 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.

I think our _big_ missing information is a definition of HOT updates and
that updating a column involved in an index disables HOT updates.

-- 
  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: <20211222221317.GD4015@momjian.us>
Permalink:  ../20211222221317.GD4015@momjian.us/
Also on:    postgresql.org/message-id/20211222221317.GD4015@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: <20211222221317.GD4015@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