diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2009-10-27 14:00:15 +0000 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2009-10-27 14:00:15 +0000 |
| commit | 0dfba4e98f7ef724839a6f446d96040645b9b487 (patch) | |
| tree | 329aefa1c1808a1368f73eacce66c6cb2bbc604c | |
| parent | 8842800d79b44882f3bb9068bd5f2d5bb69d4ccd (diff) | |
| download | postgresql-0dfba4e98f7ef724839a6f446d96040645b9b487.tar.gz postgresql-0dfba4e98f7ef724839a6f446d96040645b9b487.zip | |
Fix documentation on the toast.fillfactor reloption: it doesn't exist.
Per note from Zoltan Boszormenyi.
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 13 |
1 files changed, 7 insertions, 6 deletions
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 64971752eb4..ad64cd32b7a 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.114 2009/02/12 13:25:33 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.114.2.1 2009/10/27 14:00:15 alvherre Exp $ PostgreSQL documentation --> @@ -695,8 +695,8 @@ and <replaceable class="PARAMETER">table_constraint</replaceable> is: <literal>PRIMARY KEY</literal> constraint. Storage parameters for indexes are documented in <xref linkend="SQL-CREATEINDEX" endterm="sql-createindex-title">. The storage parameters currently - available for tables are listed below. For each parameter, there is an - additional, identically named parameter, prefixed with + available for tables are listed below. For each parameter, unless noted, + there is an additional, identically named parameter, prefixed with <literal>toast.</literal> which can be used to control the behavior of the supplementary storage table, if any; see <xref linkend="storage-toast">. Note that the supplementary storage table inherits the @@ -707,7 +707,7 @@ and <replaceable class="PARAMETER">table_constraint</replaceable> is: <variablelist> <varlistentry> - <term><literal>fillfactor</>, <literal>toast.fillfactor</literal> (<type>integer</>)</term> + <term><literal>fillfactor</> (<type>integer</>)</term> <listitem> <para> The fillfactor for a table is a percentage between 10 and 100. @@ -719,7 +719,8 @@ and <replaceable class="PARAMETER">table_constraint</replaceable> is: original, which is more efficient than placing it on a different page. For a table whose entries are never updated, complete packing is the best choice, but in heavily updated tables smaller fillfactors are - appropriate. + appropriate. This parameter cannot be set for the supplementary + storage table. </para> </listitem> </varlistentry> @@ -833,7 +834,7 @@ and <replaceable class="PARAMETER">table_constraint</replaceable> is: </varlistentry> <varlistentry> - <term><literal>autovacuum_freeze_table_age</literal> (<type>integer</type>)</term> + <term><literal>autovacuum_freeze_table_age</literal>, <literal>toast.autovacuum_freeze_table_age</literal> (<type>integer</type>)</term> <listitem> <para> Custom <xref linkend="guc-vacuum-freeze-table-age"> parameter. |