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

Commit1a6a276

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 thedefault_statistics_target GUC var.
1 parent4a43b24 commit1a6a276

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/0122:07:58 momjian Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.65 2004/03/0117: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/0122:07:58 momjian Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.78 2004/03/0117: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)

[8]ページ先頭

©2009-2025 Movatter.jp