diff options
| author | David Rowley <drowley@postgresql.org> | 2019-06-06 12:36:37 +1200 |
|---|---|---|
| committer | David Rowley <drowley@postgresql.org> | 2019-06-06 12:36:37 +1200 |
| commit | 6c0c28383749c0ade89ac70ba6dbce9af140c0a9 (patch) | |
| tree | a6e19e308861bb3273a6e3f378a7119119a1aa35 | |
| parent | b250898c76f3a04421656f1bd8c5c520de02046d (diff) | |
| download | postgresql-6c0c28383749c0ade89ac70ba6dbce9af140c0a9.tar.gz postgresql-6c0c28383749c0ade89ac70ba6dbce9af140c0a9.zip | |
Docs: concurrent builds of partitioned indexes are not supported
Document that CREATE INDEX CONCURRENTLY is not currently supported for
indexes on partitioned tables.
Discussion: https://postgr.es/m/CAKJS1f_CErd2z9L21Q8OGLD4TgH7yw1z9MAtHTSO13sXVG-yow@mail.gmail.com
Backpatch-through: 11
| -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 30bb38bf62e..629a31ef795 100644 --- a/doc/src/sgml/ref/create_index.sgml +++ b/doc/src/sgml/ref/create_index.sgml @@ -615,6 +615,16 @@ Indexes: within a transaction block, but <command>CREATE INDEX CONCURRENTLY</command> cannot. </para> + + <para> + Concurrent builds for indexes on partitioned tables are currently not + supported. However, you may concurrently build the index on each + partition individually and then finally create the partitioned index + non-concurrently in order to reduce the time where writes to the + partitioned table will be locked out. In this case, building the + partitioned index is a metadata only operation. + </para> + </refsect2> </refsect1> |