Postgres Pro
Downloads
Home   >   mailing lists

Re: Add important info about ANALYZE after create Functional Index - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Add important info about ANALYZE after create Functional Index
Date
Msg-id 20201116145903.GA20503@alvherre.pgsql
Whole thread Raw
In response to Add important info about ANALYZE after create Functional Index  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
Responses Re: Add important info about ANALYZE after create Functional Index  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Tree view 
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.

pgsql-hackers by date:

Previous
From: Paul Guo
Date:
Subject: Re: Multi Inserts in CREATE TABLE AS - revived patch
Next
From: Peter Eisentraut
Date:
Subject: Re: Skip ExecCheckRTPerms in CTAS with no data