Hi,
Attached patch for fixing documents of "61.2. Index Access Method Functions" and
"61.6. Index Cost Estimation Functions".
I added a variable "double *indexPages" introduced by commit 5262f7a4f to the
documents and
also added its explanation. Please read and revise it because I'm a non-native
English speaker.
Regards,
Tatsuro Yamada
NTT Open Source Software Center
diff --git a/doc/src/sgml/indexam.sgml b/doc/src/sgml/indexam.sgml
index c72c522175..2ef638dc7d 100644
--- a/doc/src/sgml/indexam.sgml
+++ b/doc/src/sgml/indexam.sgml
@@ -385,7 +385,8 @@ amcostestimate (PlannerInfo *root,
Cost *indexStartupCost,
Cost *indexTotalCost,
Selectivity *indexSelectivity,
- double *indexCorrelation);
+ double *indexCorrelation,
+ double *indexPages);
</programlisting>
Estimate the costs of an index scan. This function is described fully
in <xref linkend="index-cost-estimation"/>, below.
@@ -1155,7 +1156,8 @@ amcostestimate (PlannerInfo *root,
Cost *indexStartupCost,
Cost *indexTotalCost,
Selectivity *indexSelectivity,
- double *indexCorrelation);
+ double *indexCorrelation,
+ double *indexPages);
</programlisting>
The first three parameters are inputs:
@@ -1197,7 +1199,7 @@ amcostestimate (PlannerInfo *root,
</para>
<para>
- The last four parameters are pass-by-reference outputs:
+ The last five parameters are pass-by-reference outputs:
<variablelist>
<varlistentry>
@@ -1236,6 +1238,15 @@ amcostestimate (PlannerInfo *root,
</para>
</listitem>
</varlistentry>
+
+ <varlistentry>
+ <term><parameter>*indexPages</parameter></term>
+ <listitem>
+ <para>
+ Set to number of index leaf pages
+ </para>
+ </listitem>
+ </varlistentry>
</variablelist>
</para>
@@ -1283,6 +1294,11 @@ amcostestimate (PlannerInfo *root,
table.
</para>
+ <para>
+ The <parameter>indexPages</parameter> should be set to the number of leaf pages. This is used
+ to adjust the estimate for the cost of the disk access.
+ </para>
+
<para>
When <parameter>loop_count</parameter> is greater than one, the returned numbers
should be averages expected for any one scan of the index.