Re: PoC/WIP: Extended statistics on expressions

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

In response to

Browse pgsql-hackers by date

  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)?