pgsql: docs: mention that expression indexes need analyze

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: docs: mention that expression indexes need analyze
Date: 2020-11-12 20:01:03
Message-ID: E1kdImF-0005Oo-G1@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/b740b4a86784f40a4a473dc754525919e6abbc22

Modified Files
--------------
doc/src/sgml/ref/create_index.sgml | 10 ++++++++++
1 file changed, 10 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2020-11-12 20:13:20 pgsql: doc: clarify where to find pg_type_d.h (PG 11+) and pg_type.h
Previous Message Bruce Momjian 2020-11-12 19:33:47 pgsql: doc: wire protocol data type for history file content is bytea