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

Commita4bbfb1

Browse files
committed
Use "TOAST table" in place of the vague, not-used-elsewhere phrase
"supplementary storage table".
1 parent9ead05b commita4bbfb1

File tree

2 files changed

+17
-15
lines changed

2 files changed

+17
-15
lines changed

‎doc/src/sgml/ref/alter_table.sgml

Lines changed: 6 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.112 2010/04/03 07:22:57 petere Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.113 2010/05/13 18:54:18 tgl Exp $
33
PostgreSQL documentation
44
-->
55

@@ -200,17 +200,18 @@ ALTER TABLE <replaceable class="PARAMETER">name</replaceable>
200200
<listitem>
201201
<para>
202202
This form sets the storage mode for a column. This controls whether this
203-
column is held inline or in a supplementary table, and whether the data
203+
column is held inline or in a secondary <acronym>TOAST</> table, and
204+
whether the data
204205
should be compressed or not. <literal>PLAIN</literal> must be used
205206
for fixed-length values such as <type>integer</type> and is
206207
inline, uncompressed. <literal>MAIN</literal> is for inline,
207208
compressible data. <literal>EXTERNAL</literal> is for external,
208209
uncompressed data, and <literal>EXTENDED</literal> is for external,
209210
compressed data. <literal>EXTENDED</literal> is the default for most
210211
data types that support non-<literal>PLAIN</literal> storage.
211-
Use of <literal>EXTERNAL</literal> will
212-
make substring operations on<type>text</type> and <type>bytea</type>
213-
columns faster,at the penalty of increased storage space. Note that
212+
Use of <literal>EXTERNAL</literal> will make substring operations on
213+
very large<type>text</type> and <type>bytea</type> values run faster,
214+
at the penalty of increased storage space. Note that
214215
<literal>SET STORAGE</> doesn't itself change anything in the table,
215216
it just sets the strategy to be pursued during future table updates.
216217
See <xref linkend="storage-toast"> for more information.

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

Lines changed: 11 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.126 2010/04/16 02:22:33 momjian Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.127 2010/05/13 18:54:18 tgl Exp $
33
PostgreSQL documentation
44
-->
55

@@ -152,7 +152,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable class="PAR
152152
table is going to be used in complex queries, it is wise to run
153153
<command>ANALYZE</> on the temporary table after it is populated.
154154
</para>
155-
155+
156156
<para>
157157
Optionally, <literal>GLOBAL</literal> or <literal>LOCAL</literal>
158158
can be written before <literal>TEMPORARY</> or <literal>TEMP</>.
@@ -803,13 +803,15 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable class="PAR
803803
for tables, and for indexes associated with a <literal>UNIQUE</literal>,
804804
<literal>PRIMARY KEY</literal>, or <literal>EXCLUDE</> constraint.
805805
Storage parameters for
806-
indexes are documented in <xref linkend="SQL-CREATEINDEX">. The storage parameters currently
806+
indexes are documented in <xref linkend="SQL-CREATEINDEX">.
807+
The storage parameters currently
807808
available for tables are listed below. For each parameter, unless noted,
808-
there is an additional, identically named parameter, prefixed with
809-
<literal>toast.</literal> which can be used to control the behavior of the
810-
supplementary storage table, if any; see <xref linkend="storage-toast">.
811-
Note that the supplementary storage table inherits the
812-
<literal>autovacuum</literal> values from its parent table, if there are
809+
there is an additional parameter with the same name prefixed with
810+
<literal>toast.</literal>, which can be used to control the behavior of the
811+
table's secondary <acronym>TOAST</> table, if any
812+
(see <xref linkend="storage-toast"> for more information about TOAST).
813+
Note that the TOAST table inherits the
814+
<literal>autovacuum_*</literal> values from its parent table, if there are
813815
no <literal>toast.autovacuum_*</literal> settings set.
814816
</para>
815817

@@ -828,8 +830,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable class="PAR
828830
original, which is more efficient than placing it on a different page.
829831
For a table whose entries are never updated, complete packing is the
830832
best choice, but in heavily updated tables smaller fillfactors are
831-
appropriate. This parameter cannot be set for the supplementary
832-
storage table.
833+
appropriate. This parameter cannot be set for TOAST tables.
833834
</para>
834835
</listitem>
835836
</varlistentry>

0 commit comments

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