| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
| 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 15:26:37 |
| Message-ID: | 20201116152637.GA22426@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Nov 16, 2020 at 11:59:03AM -0300, Álvaro Herrera wrote:
> 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.
Applied to all branches. Thanks for the review.
--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EnterpriseDB https://enterprisedb.com
The usefulness of a cup is in its emptiness, Bruce Lee
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2020-11-16 15:27:46 | Re: PoC/WIP: Extended statistics on expressions |
| Previous Message | Andrew Dunstan | 2020-11-16 15:15:25 | Re: default result formats setting |