Commitc285a24

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 parent6b045ca commitc285a24Copy full SHA for c285a24

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
`@@ -823,6 +823,12 @@ Indexes:`
`823`	`823`	`to remove an index.`
`824`	`824`	`</para>`
`825`	`825`
	`826`	`+ <para>`
	`827`	`+ Like any long-running transaction, <command>CREATE INDEX</command> on a`
	`828`	`+ table can affect which tuples can be removed by concurrent`
	`829`	`+ <command>VACUUM</command> on any other table.`
	`830`	`+ </para>`
	`831`	`+`
`826`	`832`	`<para>`
`827`	`833`	`Prior releases of <productname>PostgreSQL</productname> also had an`
`828`	`834`	`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
`@@ -404,6 +404,12 @@ Indexes:`
`404`	`404`	`CONCURRENTLY</command> cannot.`
`405`	`405`	`</para>`
`406`	`406`
	`407`	`+ <para>`
	`408`	`+ Like any long-running transaction, <command>REINDEX</command> on a table`
	`409`	`+ can affect which tuples can be removed by concurrent`
	`410`	`+ <command>VACUUM</command> on any other table.`
	`411`	`+ </para>`
	`412`	`+`
`407`	`413`	`<para>`
`408`	`414`	`<command>REINDEX SYSTEM</command> does not support`
`409`	`415`	`<command>CONCURRENTLY</command> since system catalogs cannot be reindexed`

Comments

(0)