|
1 | | -<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.578 2008/02/02 23:30:23 tgl Exp $ --> |
| 1 | +<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.579 2008/02/07 22:28:54 momjian Exp $ --> |
2 | 2 | <!-- |
3 | 3 |
|
4 | 4 | Typical markup: |
@@ -741,10 +741,11 @@ current_date < 2017-11-17 |
741 | 741 | <command>UPDATE</>s and <command>DELETE</>s leave dead tuples |
742 | 742 | behind, as do failed <command>INSERT</>s. Previously only |
743 | 743 | <command>VACUUM</> could reclaim space taken by dead tuples. With |
744 | | - <acronym>HOT</> dead tuple space can be reclaimed at the time of |
745 | | - <command>INSERT</> or <command>UPDATE</> if no changes are made to |
746 | | - indexed columns. This allows for more consistent performance. |
747 | | - Also, <acronym>HOT</> avoids adding duplicate index entries. |
| 744 | + <acronym>HOT</> dead tuple space can be automatically reclaimed at |
| 745 | + the time of <command>INSERT</> or <command>UPDATE</> if no changes |
| 746 | + are made to indexed columns. This allows for more consistent |
| 747 | + performance. Also, <acronym>HOT</> avoids adding duplicate index |
| 748 | + entries. |
748 | 749 | </para> |
749 | 750 | </listitem> |
750 | 751 |
|
|