Commit6c0c283

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 parentb250898 commit6c0c283Copy full SHA for 6c0c283

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
`@@ -615,6 +615,16 @@ Indexes:`
`615`	`615`	`within a transaction block, but <command>CREATE INDEX CONCURRENTLY</command>`
`616`	`616`	`cannot.`
`617`	`617`	`</para>`
	`618`	`+`
	`619`	`+ <para>`
	`620`	`+ Concurrent builds for indexes on partitioned tables are currently not`
	`621`	`+ supported. However, you may concurrently build the index on each`
	`622`	`+ partition individually and then finally create the partitioned index`
	`623`	`+ non-concurrently in order to reduce the time where writes to the`
	`624`	`+ partitioned table will be locked out. In this case, building the`
	`625`	`+ partitioned index is a metadata only operation.`
	`626`	`+ </para>`
	`627`	`+`
`618`	`628`	`</refsect2>`
`619`	`629`	`</refsect1>`
`620`	`630`

Comments

(0)