I suggest to add some kind of reference to stats expressions here.
--- a/doc/src/sgml/maintenance.sgml
+++ b/doc/src/sgml/maintenance.sgml
<sect2 id="vacuum-for-statistics">
<title>Updating Planner Statistics</title>
<indexterm zone="vacuum-for-statistics">
<primary>statistics</primary>
<secondary>of the planner</secondary>
</indexterm>
[...]
@@ -330,10 +330,12 @@
<para>
Also, by default there is limited information available about
- the selectivity of functions. However, if you create an expression
+ the selectivity of functions. However, if you create a statistics
+ expression or an expression
index that uses a function call, useful statistics will be
gathered about the function, which can greatly improve query
plans that use the expression index.
--
Justin