Thread: pgsql: docs: mention that expression indexes need analyze
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(+)
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
On 2020-11-12 21:29, Erik Rijkers wrote: > 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. >> > This change contains: > 'The regularly system' > > where probably was meant: > 'The regular system' Oh, it should of course be: 'The system regularly' 'The system regularly collects statistics' ...