Re: HOT readme missing documentation on summarizing index handling - Mailing list pgsql-hackers

From Tomas Vondra
Subject Re: HOT readme missing documentation on summarizing index handling
Date
Msg-id 8ae0137b-7ac6-d27d-9695-4d2ba676ee16@enterprisedb.com
Whole thread Raw
In response to HOT readme missing documentation on summarizing index handling  (Matthias van de Meent <boekewurm+postgres@gmail.com>)
Responses Re: HOT readme missing documentation on summarizing index handling
List pgsql-hackers
Yeah, README.HOT should have been updated, and I see no reason not to
backpatch this to v16. Barring objections, I'll do that tomorrow.

I have two suggesting regarding the README.HOT changes:

1) I'm not entirely sure it's very clear what "referential integrity of
indexes across tuple updates" actually means. I'm afraid "referential
integrity" may lead readers to think about foreign keys. Maybe it'd be
better to explain this is about having index pointers to the new tuple
version, etc.

2) Wouldn't it be good to make it a bit more explicit we now have three
"levels" of HOT:

  (a) no indexes need update
  (b) update only summarizing indexes
  (c) update all indexes

The original text was really about on/off, and I'm not quite sure the
part about "exception" makes this very clear.


regards

-- 
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: [PoC] Federated Authn/z with OAUTHBEARER
Next
From: Paul A Jungwirth
Date:
Subject: Re: SQL:2011 application time