From 287e724a597011d5ceb7326d367b9a1d4b406d4f Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sun, 16 Dec 2007 13:05:30 +0000 Subject: [PATCH] Mention that HOT helps with DELETE space reuse. --- doc/src/sgml/release.sgml | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml index 479869b3ea..ec3cfda789 100644 --- a/doc/src/sgml/release.sgml +++ b/doc/src/sgml/release.sgml @@ -204,7 +204,7 @@ do it for earlier branch release files. Heap-Only Tuples (HOT) accelerate space reuse for - most UPDATEs + most UPDATEs and DELETEs @@ -736,7 +736,8 @@ current_date < 2017-11-17 Heap-Only Tuples (HOT) accelerate space reuse for most - UPDATEs (Pavan Deolasee, with ideas from many others) + UPDATEs and DELETEs (Pavan Deolasee, with + ideas from many others) @@ -744,7 +745,7 @@ current_date < 2017-11-17 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 if no changes are made to + INSERT or UPDATE if no changes are made to indexed columns. This allows for more consistent performance. Also, HOT avoids adding duplicate index entries. -- 2.39.5