Horton

Re: Add important info about ANALYZE after create Functional Index

Alvaro Herrera <alvherre@alvh.no-ip.org>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Bruce Momjian <bruce@momjian.us>
Cc: Justin Pryzby <pryzby@telsasoft.com>, Nikolay Samokhvalov <samokhvalov@gmail.com>, fabriziomello@gmail.com, pgsql-hackers@lists.postgresql.org
Date: 2020-11-16T14:59:03Z
Lists: pgsql-hackers 
On 2020-Nov-12, Bruce Momjian wrote:

>     For new expression indexes, it is necessary to run <link
>     linkend="sql-analyze"><command>ANALYZE</command></link> or wait for
>     the <link linkend="autovacuum">autovacuum daemon</link> to analyze
> -   the table to generate statistics about new expression indexes.
> +   the table to generate statistics for these indexes.

Looks good to me.

Commits

  1. Preserve index data in pg_statistic across REINDEX CONCURRENTLY