Commit3877b1f

committed

Clarify hash index caution and copy to CREATE INDEX docs

1 parent2883674 commit3877b1fCopy full SHA for 3877b1f

File tree

+16

-2

lines changed

+16

-2

lines changed

Lines changed: 4 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -196,8 +196,10 @@ CREATE INDEX <replaceable>name</replaceable> ON <replaceable>table</replaceable>`
`196`	`196`	`<para>`
`197`	`197`	`Hash index operations are not presently WAL-logged,`
`198`	`198`	`so hash indexes might need to be rebuilt with <command>REINDEX</>`
`199`		`- after a database crash. They are also not replicated over streaming or`
`200`		`- file-based replication.`
	`199`	`+ after a database crash if there were unwritten changes.`
	`200`	`+ Also, changes to hash indexes are not replicated over streaming or`
	`201`	`+ file-based replication after the initial base backup, so they`
	`202`	`+ give wrong anwers to queries that subsequently use them.`
`201`	`203`	`For these reasons, hash index use is presently discouraged.`
`202`	`204`	`</para>`
`203`	`205`	`</caution>`

Lines changed: 12 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -451,6 +451,18 @@ Indexes:`
`451`	`451`	`they can be useful.`
`452`	`452`	`</para>`
`453`	`453`
	`454`	`+ <caution>`
	`455`	`+ <para>`
	`456`	`+ Hash index operations are not presently WAL-logged,`
	`457`	`+ so hash indexes might need to be rebuilt with <command>REINDEX</>`
	`458`	`+ after a database crash if there were unwritten changes.`
	`459`	`+ Also, changes to hash indexes are not replicated over streaming or`
	`460`	`+ file-based replication after the initial base backup, so they`
	`461`	`+ give wrong anwers to queries that subsequently use them.`
	`462`	`+ For these reasons, hash index use is presently discouraged.`
	`463`	`+ </para>`
	`464`	`+ </caution>`
	`465`	`+`
`454`	`466`	`<para>`
`455`	`467`	`Currently, only the B-tree, GiST and GIN index methods support`
`456`	`468`	`multicolumn indexes. Up to 32 fields can be specified by default.`

Comments

(0)