Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit72b1574

Browse files
committed
doc: Mention that toast_tuple_target affects also column marked as Main.
Previously it was documented that toast_tuple_target affected columnmarked as only External or Extended. But this description is not correctand toast_tuple_target affects also column marked as Main.Back-patch to v11 where toast_tuple_target reloption was introduced.Author: Shinya OkanoReviewed-by: Tatsuhito Kasahara, Fujii MasaoDiscussion:https://postgr.es/m/93f46e311a67422e89e770d236059817@oss.nttdata.com
1 parentc7e2364 commit72b1574

File tree

1 file changed

+5
-4
lines changed

1 file changed

+5
-4
lines changed

‎doc/src/sgml/ref/create_table.sgml

Lines changed: 5 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1349,10 +1349,11 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
13491349
<listitem>
13501350
<para>
13511351
The toast_tuple_target specifies the minimum tuple length required before
1352-
we try to move long column values into TOAST tables, and is also the
1353-
target length we try to reduce the length below once toasting begins.
1354-
This only affects columns marked as either External or Extended
1355-
and applies only to new tuples - there is no effect on existing rows.
1352+
we try to compress and/or move long column values into TOAST tables, and
1353+
is also the target length we try to reduce the length below once toasting
1354+
begins. This affects columns marked as External (for move),
1355+
Main (for compression), or Extended (for both) and applies only to new
1356+
tuples. There is no effect on existing rows.
13561357
By default this parameter is set to allow at least 4 tuples per block,
13571358
which with the default blocksize will be 2040 bytes. Valid values are
13581359
between 128 bytes and the (blocksize - header), by default 8160 bytes.

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp