Postgres Pro
Downloads
Home   >   mailing lists

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

From Bruce Momjian
Subject Re: Add important info about ANALYZE after create Functional Index
Date
Msg-id 20201116152637.GA22426@momjian.us
Whole thread Raw
In response to Re: Add important info about ANALYZE after create Functional Index  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-hackers
Tree view 
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@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

  The usefulness of a cup is in its emptiness, Bruce Lee

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: default result formats setting
Next
From: Tomas Vondra
Date:
Subject: Re: PoC/WIP: Extended statistics on expressions