File tree Expand file tree Collapse file tree 3 files changed +18
-10
lines changed Expand file tree Collapse file tree 3 files changed +18
-10
lines changed Original file line number Diff line number Diff line change 1
1
<!--
2
- $PostgreSQL: pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.64 2003/12 /01 22:07:58 momjian Exp $
2
+ $PostgreSQL: pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.65 2004/03 /01 17:58:39 neilc Exp $
3
3
PostgreSQL documentation
4
4
-->
5
5
@@ -114,7 +114,10 @@ ALTER TABLE <replaceable class="PARAMETER">name</replaceable>
114
114
sets the per-column statistics-gathering target for subsequent
115
115
<xref linkend="sql-analyze" endterm="sql-analyze-title"> operations.
116
116
The target can be set in the range 0 to 1000; alternatively, set it
117
- to -1 to revert to using the system default statistics target.
117
+ to -1 to revert to using the system default statistics
118
+ target. For more information on the use of statistics by the
119
+ <productname>PostgreSQL</productname> query planner, refer to
120
+ <xref linkend="planner-stats">.
118
121
</para>
119
122
</listitem>
120
123
</varlistentry>
Original file line number Diff line number Diff line change 1
1
<!--
2
- $PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.77 2003/12 /01 22:07:58 momjian Exp $
2
+ $PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.78 2004/03 /01 17:58:39 neilc Exp $
3
3
PostgreSQL documentation
4
4
-->
5
5
@@ -151,7 +151,10 @@ and <replaceable class="PARAMETER">table_constraint</replaceable> is:
151
151
<term><replaceable class="PARAMETER">data_type</replaceable></term>
152
152
<listitem>
153
153
<para>
154
- The data type of the column. This may include array specifiers.
154
+ The data type of the column. This may include array
155
+ specifiers. For more information on the data types included with
156
+ <productname>PostgreSQL</productname>, refer to <xref
157
+ linkend="datatype">.
155
158
</para>
156
159
</listitem>
157
160
</varlistentry>
Original file line number Diff line number Diff line change 1
1
<!--
2
- $PostgreSQL: pgsql/doc/src/sgml/runtime.sgml,v 1.242 2004/02/23 20:45:58 tgl Exp $
2
+ $PostgreSQL: pgsql/doc/src/sgml/runtime.sgml,v 1.243 2004/03/01 17:58:39 neilc Exp $
3
3
-->
4
4
5
5
<Chapter Id="runtime">
@@ -1562,11 +1562,13 @@ SET ENABLE_SEQSCAN TO OFF;
1562
1562
<term><varname>default_statistics_target</varname> (<type>integer</type>)</term>
1563
1563
<listitem>
1564
1564
<para>
1565
- Sets the default statistics target for table columns that have not
1566
- had a column-specific target set via <command>ALTER TABLE SET
1567
- STATISTICS</>. Larger values increase the time needed to do
1568
- <command>ANALYZE</>, but may improve the quality of the planner's
1569
- estimates. The default is 10.
1565
+ Sets the default statistics target for table columns that have
1566
+ not had a column-specific target set via <command>ALTER TABLE
1567
+ SET STATISTICS</>. Larger values increase the time needed to
1568
+ do <command>ANALYZE</>, but may improve the quality of the
1569
+ planner's estimates. The default is 10. For more information
1570
+ on the use of statistics by the <productname>PostgreSQL</>
1571
+ query planner, refer to <xref linkend="planner-stats">.
1570
1572
</para>
1571
1573
</listitem>
1572
1574
</varlistentry>
You can’t perform that action at this time.
0 commit comments