Re: pgsql: docs: mention that expression indexes need analyze

From: Erik Rijkers <er(at)xs4all(dot)nl>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: Re: pgsql: docs: mention that expression indexes need analyze
Date: 2020-11-12 20:29:20
Message-ID: 71b04801912e74065ae9ea6a3ec1d13d@xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

On 2020-11-12 21:01, Bruce Momjian wrote:
> docs: mention that expression indexes need analyze
>
> Expression indexes can't benefit from pre-computed statistics on
> columns.
>
> Reported-by: Nikolay Samokhvalov
>
> Discussion:
> https://postgr.es/m/CANNMO++5rw9RDA=p40iMVbMNPaW6O=S0AFzTU=KpYHRpCd1voA@mail.gmail.com
>
> Author: Nikolay Samokhvalov, modified
>
> Backpatch-through: 9.5
>
> Branch
> ------
> REL_12_STABLE
>
> Details
> -------
> https://git.postgresql.org/pg/commitdiff/90fdc259866ed800283620c8fe6329015ad58e5c
>
> Modified Files
> --------------
> doc/src/sgml/ref/create_index.sgml | 10 ++++++++++
> 1 file changed, 10 insertions(+)

Hi,

This change contains:
'The regularly system'

where probably was meant:
'The regular system'

I think that dropping the word 'regular' entirely is even better.

thanks,

Erik Rijkers

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Erik Rijkers 2020-11-12 20:50:38 Re: pgsql: docs: mention that expression indexes need analyze
Previous Message Alvaro Herrera 2020-11-12 20:29:00 Re: pgsql: doc: clarify where to find pg_type_d.h (PG 11+) and pg_type.h