From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
---|---|
To: | Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>, PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org> |
Subject: | Re: Indexes on Expressions - a note to remind users to run ANALYZE after creation |
Date: | 2021-07-19 10:59:10 |
Message-ID: | 77bbd451633a2852181fc6259baf9796361ce2a1.camel@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
On Fri, 2021-07-16 at 22:00 -0700, Nikolay Samokhvalov wrote:
> 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>
I agree in principle. It should be "has been created" rather than "is created",
and I would say something less drastic like "usually a good idea" rather than
"important".
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2021-07-19 14:23:55 | Re: Manua correction |
Previous Message | Masahiko Sawada | 2021-07-19 08:27:10 | Re: Update maintenance_work_mem/autovacuum_work_mem to reflect the 1GB limitation with VACUUM |