|
1 | | -<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.560 2007/12/0716:53:31 momjian Exp $ --> |
| 1 | +<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.561 2007/12/0717:42:49 momjian Exp $ --> |
2 | 2 | <!-- |
3 | 3 |
|
4 | 4 | Typical markup: |
@@ -703,13 +703,13 @@ current_date < 2017-11-17 |
703 | 703 | </para> |
704 | 704 |
|
705 | 705 | <para> |
706 | | - <command>UPDATE</>s and <command>DELETE</>s leave dead tuples behind, |
707 | | - as do failed <command>INSERT</>s. Previously only |
| 706 | + <command>UPDATE</>s and <command>DELETE</>s leave dead tuples |
| 707 | +behind,as do failed <command>INSERT</>s. Previously only |
708 | 708 | <command>VACUUM</> could reclaim space taken by dead tuples. With |
709 | 709 | <acronym>HOT</> dead tuple space can be reclaimed at the time of |
710 | | - <command>UPDATE</> or <command>INSERT</>. This allows for more |
711 | | -consistent performance.Also, <acronym>HOT</> avoids making duplicate |
712 | | -index entries when an <command>UPDATE</>changes no indexed columns. |
| 710 | + <command>UPDATE</> or <command>INSERT</> if no changes are made to |
| 711 | +indexed columns.This allows for more consistent performance. |
| 712 | +Also, <acronym>HOT</>avoids adding duplicate index entries. |
713 | 713 | </para> |
714 | 714 | </listitem> |
715 | 715 |
|
|