Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

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

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit5c38782

Browse files
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 commit5c38782

File tree

2 files changed

+6
-6
lines changed

2 files changed

+6
-6
lines changed

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

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1845,8 +1845,7 @@ LOG: database system is ready to accept read only connections
18451845
<listitem>
18461846
<para>
18471847
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.
18501849
</para>
18511850
</listitem>
18521851
<listitem>

‎doc/src/sgml/indices.sgml

Lines changed: 5 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -187,14 +187,15 @@ CREATE INDEX <replaceable>name</replaceable> ON <replaceable>table</replaceable>
187187
</synopsis>
188188
</para>
189189

190-
<note>
190+
<caution>
191191
<para>
192192
Hash index operations are not presently WAL-logged,
193193
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.
196197
</para>
197-
</note>
198+
</caution>
198199

199200
<para>
200201
<indexterm>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp