Re: Add important info about ANALYZE after create Functional Index

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Justin Pryzby <pryzby(at)telsasoft(dot)com>, Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>, fabriziomello(at)gmail(dot)com, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Add important info about ANALYZE after create Functional Index
Date: 2020-11-16 14:59:03
Message-ID: 20201116145903.GA20503@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2020-11-16 14:59:31 Re: Add important info about ANALYZE after create Functional Index
Previous Message Paul Guo 2020-11-16 14:32:30 Re: Multi Inserts in CREATE TABLE AS - revived patch