Commit259b212

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 parent3e214fa commit259b212Copy full SHA for 259b212

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
`@@ -786,6 +786,12 @@ Indexes:`
`786`	`786`	`to remove an index.`
`787`	`787`	`</para>`
`788`	`788`
	`789`	`+ <para>`
	`790`	`+ Like any long-running transaction, <command>CREATE INDEX</command> on a`
	`791`	`+ table can affect which tuples can be removed by concurrent`
	`792`	`+ <command>VACUUM</command> on any other table.`
	`793`	`+ </para>`
	`794`	`+`
`789`	`795`	`<para>`
`790`	`796`	`Prior releases of <productname>PostgreSQL</productname> also had an`
`791`	`797`	`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
`@@ -401,6 +401,12 @@ Indexes:`
`401`	`401`	`CONCURRENTLY</command> cannot.`
`402`	`402`	`</para>`
`403`	`403`
	`404`	`+ <para>`
	`405`	`+ Like any long-running transaction, <command>REINDEX</command> on a table`
	`406`	`+ can affect which tuples can be removed by concurrent`
	`407`	`+ <command>VACUUM</command> on any other table.`
	`408`	`+ </para>`
	`409`	`+`
`404`	`410`	`<para>`
`405`	`411`	`<command>REINDEX SYSTEM</command> does not support`
`406`	`412`	`<command>CONCURRENTLY</command> since system catalogs cannot be reindexed`

Comments

(0)