Commita15e8ce

committed

Docs: concurrent builds of partitioned indexes are not supported

Document that CREATE INDEX CONCURRENTLY is not currently supported forindexes on partitioned tables.Discussion:https://postgr.es/m/CAKJS1f_CErd2z9L21Q8OGLD4TgH7yw1z9MAtHTSO13sXVG-yow@mail.gmail.comBackpatch-through: 11

1 parenta99b653 commita15e8ceCopy full SHA for a15e8ce

File tree

+10

-0

lines changed

+10

-0

lines changed

Lines changed: 10 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -586,6 +586,16 @@ Indexes:`
`586`	`586`	`within a transaction block, but <command>CREATE INDEX CONCURRENTLY</command>`
`587`	`587`	`cannot.`
`588`	`588`	`</para>`
	`589`	`+`
	`590`	`+ <para>`
	`591`	`+ Concurrent builds for indexes on partitioned tables are currently not`
	`592`	`+ supported. However, you may concurrently build the index on each`
	`593`	`+ partition individually and then finally create the partitioned index`
	`594`	`+ non-concurrently in order to reduce the time where writes to the`
	`595`	`+ partitioned table will be locked out. In this case, building the`
	`596`	`+ partitioned index is a metadata only operation.`
	`597`	`+ </para>`
	`598`	`+`
`589`	`599`	`</refsect2>`
`590`	`600`	`</refsect1>`
`591`	`601`

Comments

(0)