Indexes on Expressions - a note to remind users to run ANALYZE after creation

From: Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>
To: PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org>
Subject: Indexes on Expressions - a note to remind users to run ANALYZE after creation
Date: 2021-07-17 05:00:20
Message-ID: CANNMO+K179bhRrzsJZn-tS8evH4uRSonCUHoMQdRCSvzmKyo1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

diff --git a/doc/src/sgml/indices.sgml b/doc/src/sgml/indices.sgml
index 671299ff059d972ff95bdb1d67ed4c89bf5040b2..c7eaf9a608e995ef9957b4e0f677b36a8303be55
100644
--- a/doc/src/sgml/indices.sgml
+++ b/doc/src/sgml/indices.sgml
@@ -741,6 +741,15 @@ CREATE INDEX people_names ON people ((first_name
|| ' ' || last_name));
query. Thus, indexes on expressions are useful when retrieval speed
is more important than insertion and update speed.
</para>
+
+ <note>
+ <title>Note</title>
+ <para>
+ Once an index on an expression is successfully created, it is important to
+ run <literal>ANALYZE</literal> on the corresponding table to gather
+ statistics for the expression.
+ </para>
+ </note>
</sect1>

{"mode":"full","isActive":false}

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Nikolay Samokhvalov 2021-07-17 05:56:31 Re: user-defined function in Perl or Tcl ???
Previous Message Doug Tracy 2021-07-16 19:18:11 Logical error