diff options
| author | Bruce Momjian <bruce@momjian.us> | 2020-11-12 15:00:44 -0500 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2020-11-12 15:00:44 -0500 |
| commit | 337020798674bcdfefe93e2277d98458da7266cd (patch) | |
| tree | 760831bcb5590ccb0caaa1b4496e72c29d419781 /doc/src | |
| parent | 66a8f090485e3e897a4804121fdbe856cba72d70 (diff) | |
| download | postgresql-337020798674bcdfefe93e2277d98458da7266cd.tar.gz postgresql-337020798674bcdfefe93e2277d98458da7266cd.zip | |
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
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/create_index.sgml | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml index 749db2845e8..844f00904be 100644 --- a/doc/src/sgml/ref/create_index.sgml +++ b/doc/src/sgml/ref/create_index.sgml @@ -746,6 +746,16 @@ Indexes: </para> <para> + The regularly system collects statistics on all of a table's + columns. Newly-created non-expression indexes can immediately + use these statistics to determine an index's usefulness. + 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. + </para> + + <para> For most index methods, the speed of creating an index is dependent on the setting of <xref linkend="guc-maintenance-work-mem"/>. Larger values will reduce the time needed for index creation, so long |