Re: PoC/WIP: Extended statistics on expressions

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема Re: PoC/WIP: Extended statistics on expressions
Дата
Msg-id 20210423025012.GI7256@telsasoft.com
обсуждение исходный текст
Ответ на Re: PoC/WIP: Extended statistics on expressions  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Список 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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bharath Rupireddy
Дата:
Сообщение: Re: PageGetItemIdCareful - should we MAXALIGN sizeof(BTPageOpaqueData)?
Следующее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: Support tab completion for upper character inputs in psql