NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit5c38782

committed

Note explicitly that hash indexes are also not replicated because they're not

WAL-logged. Make the notice about the lack of WAL-logging more visible bymaking it a <caution>. Also remove the false statement from hot standbycaveats section that hash indexes are not used during hot standby.

1 parent3579a94 commit5c38782Copy full SHA for 5c38782

File tree

2 files changed

-6

lines changed

doc/src/sgml
- high-availability.sgml
- indices.sgml

2 files changed

-6

lines changed

`‎doc/src/sgml/high-availability.sgml`

Lines changed: 1 addition & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1845,8 +1845,7 @@ LOG: database system is ready to accept read only connections`
`1845`	`1845`	`<listitem>`
`1846`	`1846`	`<para>`
`1847`	`1847`	`Operations on hash indexes are not presently WAL-logged, so`
`1848`		`- replay will not update these indexes. Hash indexes will not be`
`1849`		`- used for query plans during recovery.`
	`1848`	`+ replay will not update these indexes.`
`1850`	`1849`	`</para>`
`1851`	`1850`	`</listitem>`
`1852`	`1851`	`<listitem>`

`‎doc/src/sgml/indices.sgml`

Lines changed: 5 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -187,14 +187,15 @@ CREATE INDEX <replaceable>name</replaceable> ON <replaceable>table</replaceable>`
`187`	`187`	`</synopsis>`
`188`	`188`	`</para>`
`189`	`189`
`190`		`- <note>`
	`190`	`+ <caution>`
`191`	`191`	`<para>`
`192`	`192`	`Hash index operations are not presently WAL-logged,`
`193`	`193`	`so hash indexes might need to be rebuilt with <command>REINDEX</>`
`194`		`- after a database crash.`
`195`		`- For this reason, hash index use is presently discouraged.`
	`194`	`+ after a database crash. They are also not replicated over streaming or`
	`195`	`+ file-based replication.`
	`196`	`+ For these reasons, hash index use is presently discouraged.`
`196`	`197`	`</para>`
`197`		`- </note>`
	`198`	`+ </caution>`
`198`	`199`
`199`	`200`	`<para>`
`200`	`201`	`<indexterm>`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit5c38782

File tree

2 files changed

2 files changed

`‎doc/src/sgml/high-availability.sgml`

`‎doc/src/sgml/indices.sgml`

0 commit comments