docs: mention that expression indexes need analyze
authorBruce Momjian <bruce@momjian.us>
Thu, 12 Nov 2020 20:00:44 +0000 (15:00 -0500)
committerBruce Momjian <bruce@momjian.us>
Thu, 12 Nov 2020 20:00:44 +0000 (15:00 -0500)
commit90fdc259866ed800283620c8fe6329015ad58e5c
tree5dc532be7cd1a8bc59d51cc4a13e2cdf94043f85
parentd7fa90fae104a81cc5a1a76a9607afcd3d0ad070
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
doc/src/sgml/ref/create_index.sgml