summaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/create_table.sgml
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2009-10-13 00:53:08 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2009-10-13 00:53:08 +0000
commit8d54c2482b264ef621ec315f127a565ff4387042 (patch)
tree2cdcf2750faf0774806f2af6ca4ef0e77bb4a91d /doc/src/sgml/ref/create_table.sgml
parent5ec1341136941b538d07f54b2a6d7554857f8dc3 (diff)
downloadpostgresql-8d54c2482b264ef621ec315f127a565ff4387042.tar.gz
Code review for LIKE INCLUDING patch --- clean up some cosmetic and not
so cosmetic stuff.
Diffstat (limited to 'doc/src/sgml/ref/create_table.sgml')
-rw-r--r--doc/src/sgml/ref/create_table.sgml42
1 files changed, 22 insertions, 20 deletions
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml
index a63333cb6f..5768c4cf2e 100644
--- a/doc/src/sgml/ref/create_table.sgml
+++ b/doc/src/sgml/ref/create_table.sgml
@@ -1,5 +1,5 @@
<!--
-$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.117 2009/10/12 19:49:24 adunstan Exp $
+$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.118 2009/10/13 00:53:07 tgl Exp $
PostgreSQL documentation
-->
@@ -231,7 +231,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable class="PAR
</para>
<para>
- Column storage parameters are also copied from parent tables.
+ Column <literal>STORAGE</> settings are also copied from parent tables.
</para>
<!--
@@ -285,25 +285,27 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable class="PAR
specified.
</para>
<para>
- Storage parameters for the copied column definitions will only be copied
- if <literal>INCLUDING STORAGE</literal> is specified. The default
- behavior is to exclude storage parameters, resulting in the copied
- columns in the new table having type-specific default parameters. For
- more on storage parameters, see <xref linkend="storage-toast">.
+ <literal>STORAGE</> settings for the copied column definitions will only
+ be copied if <literal>INCLUDING STORAGE</literal> is specified. The
+ default behavior is to exclude <literal>STORAGE</> settings, resulting
+ in the copied columns in the new table having type-specific default
+ settings. For more on <literal>STORAGE</> settings, see
+ <xref linkend="storage-toast">.
</para>
<para>
- Comments for the copied column, constraint, index and columns of index
- definitions will only be copied if <literal>INCLUDING COMMENTS</literal>
- is specified. The default behavior is to exclude comments, resulting in
- the copied columns and constraints in the new table having no comments.
+ Comments for the copied columns, constraints, and indexes
+ will only be copied if <literal>INCLUDING COMMENTS</literal>
+ is specified. The default behavior is to exclude comments, resulting in
+ the copied columns and constraints in the new table having no comments.
</para>
<para>
<literal>INCLUDING ALL</literal> is an abbreviated form of
<literal>INCLUDING DEFAULTS INCLUDING CONSTRAINTS INCLUDING INDEXES INCLUDING STORAGE INCLUDING COMMENTS</literal>.
</para>
<para>
- Note also that unlike <literal>INHERITS</literal>, copied columns and
- constraints are not merged with similarly named columns and constraints.
+ Note also that unlike <literal>INHERITS</literal>, columns and
+ constraints copied by <literal>LIKE</> are not merged with similarly
+ named columns and constraints.
If the same name is specified explicitly or in another
<literal>LIKE</literal> clause, an error is signalled.
</para>
@@ -752,14 +754,14 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable class="PAR
<para>
Enables or disables the autovacuum daemon on a particular table.
If true, the autovacuum daemon will initiate a <command>VACUUM</> operation
- on a particular table when the number of updated or deleted tuples exceeds
- <literal>autovacuum_vacuum_threshold</> plus
- <literal>autovacuum_vacuum_scale_factor</> times the number of live tuples
+ on a particular table when the number of updated or deleted tuples exceeds
+ <literal>autovacuum_vacuum_threshold</> plus
+ <literal>autovacuum_vacuum_scale_factor</> times the number of live tuples
currently estimated to be in the relation.
Similarly, it will initiate an <command>ANALYZE</> operation when the
number of inserted, updated or deleted tuples exceeds
- <literal>autovacuum_analyze_threshold</> plus
- <literal>autovacuum_analyze_scale_factor</> times the number of live tuples
+ <literal>autovacuum_analyze_threshold</> plus
+ <literal>autovacuum_analyze_scale_factor</> times the number of live tuples
currently estimated to be in the relation.
If false, this table will not be autovacuumed, except to prevent
transaction Id wraparound. See <xref linkend="vacuum-for-wraparound"> for
@@ -775,7 +777,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable class="PAR
<listitem>
<para>
Minimum number of updated or deleted tuples before initiate a
- <command>VACUUM</> operation on a particular table.
+ <command>VACUUM</> operation on a particular table.
</para>
</listitem>
</varlistentry>
@@ -834,7 +836,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable class="PAR
<para>
Custom <xref linkend="guc-vacuum-freeze-min-age"> parameter. Note that
autovacuum will ignore attempts to set a per-table
- <literal>autovacuum_freeze_min_age</> larger than the half system-wide
+ <literal>autovacuum_freeze_min_age</> larger than the half system-wide
<xref linkend="guc-autovacuum-freeze-max-age"> setting.
</para>
</listitem>