diff options
| author | Bruce Momjian <bruce@momjian.us> | 2022-08-12 15:05:13 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2022-08-12 15:05:13 -0400 |
| commit | 4445461cdff3580a2a698e89f66efd467f1bb5df (patch) | |
| tree | 79c231a846796bfec7665e07938a8c319c13eff9 /doc/src/sgml/ref | |
| parent | 5eb38dc1efc6a83043eabbd4d26271ff232389ca (diff) | |
doc: add section about heap-only tuples (HOT)
Reported-by: Jonathan S. Katz
Discussion: https://postgr.es/m/c59ffbd5-96ac-a5a5-a401-14f627ca1405@postgresql.org
Backpatch-through: 11
Diffstat (limited to 'doc/src/sgml/ref')
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 6c9918b0a1e..833cae7c5d0 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1408,7 +1408,9 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM to the indicated percentage; the remaining space on each page is reserved for updating rows on that page. This gives <command>UPDATE</command> a chance to place the updated copy of a row on the same page as the - original, which is more efficient than placing it on a different page. + original, which is more efficient than placing it on a different + page, and makes <link linkend="storage-hot">heap-only tuple + updates</link> more likely. For a table whose entries are never updated, complete packing is the best choice, but in heavily updated tables smaller fillfactors are appropriate. This parameter cannot be set for TOAST tables. |