diff options
author | Bruce Momjian | 2007-12-16 13:05:30 +0000 |
---|---|---|
committer | Bruce Momjian | 2007-12-16 13:05:30 +0000 |
commit | d6a18f459a67dc7f4bd4de7346285af29f183182 (patch) | |
tree | 785529142200c4d91f0ae2ec90a1252dabd64ecc /doc/src | |
parent | 7b618017fdd99dafe26c6aaf107123c260ccad9e (diff) |
Mention that HOT helps with DELETE space reuse.
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/release.sgml | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml index e305ca19c02..8fd8547db60 100644 --- a/doc/src/sgml/release.sgml +++ b/doc/src/sgml/release.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.570 2007/12/16 07:19:32 momjian Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.571 2007/12/16 13:05:30 momjian Exp $ --> <!-- Typical markup: @@ -204,7 +204,7 @@ do it for earlier branch release files. <listitem> <para> Heap-Only Tuples (<acronym>HOT</>) accelerate space reuse for - most <command>UPDATE</>s + most <command>UPDATE</>s and <command>DELETE</>s </para> </listitem> @@ -736,7 +736,8 @@ current_date < 2017-11-17 <listitem> <para> Heap-Only Tuples (<acronym>HOT</>) accelerate space reuse for most - <command>UPDATE</>s (Pavan Deolasee, with ideas from many others) + <command>UPDATE</>s and <command>DELETE</>s (Pavan Deolasee, with + ideas from many others) </para> <para> @@ -744,7 +745,7 @@ current_date < 2017-11-17 behind, as do failed <command>INSERT</>s. Previously only <command>VACUUM</> could reclaim space taken by dead tuples. With <acronym>HOT</> dead tuple space can be reclaimed at the time of - <command>UPDATE</> or <command>INSERT</> if no changes are made to + <command>INSERT</> or <command>UPDATE</> if no changes are made to indexed columns. This allows for more consistent performance. Also, <acronym>HOT</> avoids adding duplicate index entries. </para> |