From 4df3337985bb6eee4f1c418a57ab3e90e1fc5aca Mon Sep 17 00:00:00 2001 From: James Coleman Date: Fri, 29 Sep 2023 17:00:56 +0000 Subject: [PATCH v3] Correct HOT docs to account for LP_REDIRECT --- doc/src/sgml/storage.sgml | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) diff --git a/doc/src/sgml/storage.sgml b/doc/src/sgml/storage.sgml index 148fb1b49d..64d47b1218 100644 --- a/doc/src/sgml/storage.sgml +++ b/doc/src/sgml/storage.sgml @@ -1121,20 +1121,20 @@ data. Empty in ordinary tables. - Old versions of updated rows can be completely removed during normal - operation, including SELECTs, instead of requiring - periodic vacuum operations. (This is possible because indexes - do not reference their page - item identifiers.) + Old, no longer visible versions of updated rows may be pruned during + normal operation, including SELECTs, instead of + requiring periodic vacuum operations. Because indexes always refer to the + page item identifiers of the + original row version, the original row version has its tuple data removed + and is changed to redirect to the oldest still-visible version. No longer + visible versions other than the original version may be removed entirely. - In summary, heap-only tuple updates can only be created - if columns used by indexes are not updated. You can - increase the likelihood of sufficient page space for + You can increase the likelihood of sufficient page space for HOT updates by decreasing a table's fillfactor. If you don't, HOT updates will still happen because -- 2.39.3 (Apple Git-145)