diff options
| author | David Rowley <drowley@postgresql.org> | 2019-06-06 12:37:04 +1200 |
|---|---|---|
| committer | David Rowley <drowley@postgresql.org> | 2019-06-06 12:37:04 +1200 |
| commit | a15e8ce7b647ccc4580bf00374c33e5ab793f3e3 (patch) | |
| tree | a54fba2fb6b622de3a6ae61fde5ad5d42be17e46 | |
| parent | a99b653ac1e6689d13d77622dd2c31309184f28c (diff) | |
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 ad619cdcfe4..3a4e71ca1cb 100644 --- a/doc/src/sgml/ref/create_index.sgml +++ b/doc/src/sgml/ref/create_index.sgml @@ -586,6 +586,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> |