From d8243816fb8973b150097fe2b39b2a1c2946c166 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Fri, 7 Dec 2007 17:42:49 +0000 Subject: [PATCH] Update HOT description to make index column changes clearer. --- doc/src/sgml/release.sgml | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml index 7e7a29ad2e..1cbc1b02ba 100644 --- a/doc/src/sgml/release.sgml +++ b/doc/src/sgml/release.sgml @@ -703,13 +703,13 @@ current_date < 2017-11-17 - UPDATEs and DELETEs leave dead tuples behind, - as do failed INSERTs. Previously only + UPDATEs and DELETEs leave dead tuples + behind, as do failed INSERTs. Previously only VACUUM could reclaim space taken by dead tuples. With HOT dead tuple space can be reclaimed at the time of - UPDATE or INSERT. This allows for more - consistent performance. Also, HOT avoids making duplicate - index entries when an UPDATE changes no indexed columns. + UPDATE or INSERT if no changes are made to + indexed columns. This allows for more consistent performance. + Also, HOT avoids adding duplicate index entries. -- 2.39.5