postgres.git / summary / log / commit / refs

commit    72b15740900cb6e0646bcdafabecbaa8eaad9e7e
Author:   Fujii Masao <fujii@postgresql.org>
Date:     Thu Oct 15 02:04:07 2020 +0000

    doc: Mention that toast_tuple_target affects also column marked as Main.
    
    Previously it was documented that toast_tuple_target affected column
    marked as only External or Extended. But this description is not correct
    and toast_tuple_target affects also column marked as Main.
    
    Back-patch to v11 where toast_tuple_target reloption was introduced.
    
    Author: Shinya Okano
    Reviewed-by: Tatsuhito Kasahara, Fujii Masao
    Discussion: https://postgr.es/m/93f46e311a67422e89e770d236059817@oss.nttdata.com


 doc/src/sgml/ref/create_table.sgml | 9 +++++----
 1 file changed, 5 insertions(+), 4 deletions(-)

diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml
index 63ea024b0c0..880021626be 100644
--- a/doc/src/sgml/ref/create_table.sgml
+++ b/doc/src/sgml/ref/create_table.sgml
@@ -1349,10 +1349,11 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
     <listitem>
      <para>
       The toast_tuple_target specifies the minimum tuple length required before
-      we try to move long column values into TOAST tables, and is also the
-      target length we try to reduce the length below once toasting begins.
-      This only affects columns marked as either External or Extended
-      and applies only to new tuples - there is no effect on existing rows.
+      we try to compress and/or move long column values into TOAST tables, and
+      is also the target length we try to reduce the length below once toasting
+      begins. This affects columns marked as External (for move),
+      Main (for compression), or Extended (for both) and applies only to new
+      tuples. There is no effect on existing rows.
       By default this parameter is set to allow at least 4 tuples per block,
       which with the default blocksize will be 2040 bytes. Valid values are
       between 128 bytes and the (blocksize - header), by default 8160 bytes.


[parent: c7e2364a5f17]