From: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
---|---|
To: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> |
Cc: | Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: PoC/WIP: Extended statistics on expressions |
Date: | 2021-04-23 02:50:12 |
Message-ID: | 20210423025012.GI7256@telsasoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Kyotaro Horiguchi | 2021-04-23 02:58:12 | Re: Support tab completion for upper character inputs in psql |
Previous Message | Bharath Rupireddy | 2021-04-23 02:39:48 | Re: PageGetItemIdCareful - should we MAXALIGN sizeof(BTPageOpaqueData)? |