Skip to content

Commit 1a6a276

Browse files
author
Neil Conway
committed
Add a few more xrefs, where they seemed appropriate: for example, refer
to the discussion of planner statistics in the documentation for the default_statistics_target GUC var.
1 parent 4a43b24 commit 1a6a276

File tree

3 files changed

+18
-10
lines changed

3 files changed

+18
-10
lines changed

doc/src/sgml/ref/alter_table.sgml

Lines changed: 5 additions & 2 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.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 $
33
PostgreSQL documentation
44
-->
55

@@ -114,7 +114,10 @@ ALTER TABLE <replaceable class="PARAMETER">name</replaceable>
114114
sets the per-column statistics-gathering target for subsequent
115115
<xref linkend="sql-analyze" endterm="sql-analyze-title"> operations.
116116
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">.
118121
</para>
119122
</listitem>
120123
</varlistentry>

doc/src/sgml/ref/create_table.sgml

Lines changed: 5 additions & 2 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.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 $
33
PostgreSQL documentation
44
-->
55

@@ -151,7 +151,10 @@ and <replaceable class="PARAMETER">table_constraint</replaceable> is:
151151
<term><replaceable class="PARAMETER">data_type</replaceable></term>
152152
<listitem>
153153
<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">.
155158
</para>
156159
</listitem>
157160
</varlistentry>

doc/src/sgml/runtime.sgml

Lines changed: 8 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
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 $
33
-->
44

55
<Chapter Id="runtime">
@@ -1562,11 +1562,13 @@ SET ENABLE_SEQSCAN TO OFF;
15621562
<term><varname>default_statistics_target</varname> (<type>integer</type>)</term>
15631563
<listitem>
15641564
<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">.
15701572
</para>
15711573
</listitem>
15721574
</varlistentry>

0 commit comments

Comments
 (0)