documentation on HOT

From: "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>
To: Pg Docs <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: documentation on HOT
Date: 2022-02-07 01:07:53
Message-ID: c59ffbd5-96ac-a5a5-a401-14f627ca1405@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Hi,

While working on the 2020-02-10 release announcement, in order to better
describe one of the fixes, I tried to find a reference in the docs that
described what HOT is, how it works, etc. in a user-friendly manner.

This lead me to the acronyms page[1], which lead me to a document in the
repo[2]. The closest thing I found was a blog post that Laurenz Albe
wrote on the topic[3].

Given the importance of HOT, it seems like this would be a good topic to
document. I would suggest something higher-level for general users in
the "Indexes"[4] section, and something lower-level in internals[5]
(which could perhaps be derived from [2]).

Thoughts on this?

Thanks,

Jonathan

[1] https://www.postgresql.org/docs/current/acronyms.html
[2]
https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/access/heap/README.HOT;hb=HEAD
[3]
https://www.cybertec-postgresql.com/en/hot-updates-in-postgresql-for-better-performance/
[4] https://www.postgresql.org/docs/current/indexes.html
[5] https://www.postgresql.org/docs/current/internals.html

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2022-02-07 01:56:32 Re: documentation on HOT
Previous Message PG Doc comments form 2022-02-05 01:22:51 Transactions in postgres