diff options
| author | Fujii Masao <fujii@postgresql.org> | 2020-10-15 11:04:07 +0900 |
|---|---|---|
| committer | Fujii Masao <fujii@postgresql.org> | 2020-10-15 11:07:43 +0900 |
| commit | 72b15740900cb6e0646bcdafabecbaa8eaad9e7e (patch) | |
| tree | fab25629b303909e67a51771f4e4b1f26ea0ff2a | |
| parent | c7e2364a5f17b3ef3518f92542fb1b1628288382 (diff) | |
| download | postgresql-72b15740900cb6e0646bcdafabecbaa8eaad9e7e.tar.gz postgresql-72b15740900cb6e0646bcdafabecbaa8eaad9e7e.zip | |
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
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 9 |
1 files 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. |