Commit93c39f9

committed

Call out vacuum considerations in create index docs

Backpatch to pg12, which is as far as it goes without conflicts.Author: James Coleman <jtc331@gmail.com>Reviewed-by: "David G. Johnston" <david.g.johnston@gmail.com>Discussion:https://postgr.es/m/CAAaqYe9oEfbz7AxXq7OX+FFVi5w5p1e_Of8ON8ZnKO9QqBfmjg@mail.gmail.com

1 parentc21ea4d commit93c39f9Copy full SHA for 93c39f9

File tree

+12

-0

lines changed

+12

-0

lines changed

Lines changed: 6 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -851,6 +851,12 @@ Indexes:`
`851`	`851`	`to remove an index.`
`852`	`852`	`</para>`
`853`	`853`
	`854`	`+ <para>`
	`855`	`+ Like any long-running transaction, <command>CREATE INDEX</command> on a`
	`856`	`+ table can affect which tuples can be removed by concurrent`
	`857`	`+ <command>VACUUM</command> on any other table.`
	`858`	`+ </para>`
	`859`	`+`
`854`	`860`	`<para>`
`855`	`861`	`Prior releases of <productname>PostgreSQL</productname> also had an`
`856`	`862`	`R-tree index method. This method has been removed because`

Lines changed: 6 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -436,6 +436,12 @@ Indexes:`
`436`	`436`	`CONCURRENTLY</command> cannot.`
`437`	`437`	`</para>`
`438`	`438`
	`439`	`+ <para>`
	`440`	`+ Like any long-running transaction, <command>REINDEX</command> on a table`
	`441`	`+ can affect which tuples can be removed by concurrent`
	`442`	`+ <command>VACUUM</command> on any other table.`
	`443`	`+ </para>`
	`444`	`+`
`439`	`445`	`<para>`
`440`	`446`	`<command>REINDEX SYSTEM</command> does not support`
`441`	`447`	`<command>CONCURRENTLY</command> since system catalogs cannot be reindexed`

Comments

(0)