From b887f7b3526627d22d01d0cdb74a21ead08934a7 Mon Sep 17 00:00:00 2001 From: Heikki Linnakangas Date: Tue, 26 Oct 2010 22:50:31 +0300 Subject: [PATCH] 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 by making it a . Also remove the false statement from hot standby caveats section that hash indexes are not used during hot standby. --- doc/src/sgml/high-availability.sgml | 3 +-- doc/src/sgml/indices.sgml | 9 +++++---- 2 files changed, 6 insertions(+), 6 deletions(-) diff --git a/doc/src/sgml/high-availability.sgml b/doc/src/sgml/high-availability.sgml index eabd844fa3..74684f7d0c 100644 --- a/doc/src/sgml/high-availability.sgml +++ b/doc/src/sgml/high-availability.sgml @@ -1845,8 +1845,7 @@ LOG: database system is ready to accept read only connections Operations on hash indexes are not presently WAL-logged, so - replay will not update these indexes. Hash indexes will not be - used for query plans during recovery. + replay will not update these indexes. diff --git a/doc/src/sgml/indices.sgml b/doc/src/sgml/indices.sgml index a28f1dba51..1b02f5f563 100644 --- a/doc/src/sgml/indices.sgml +++ b/doc/src/sgml/indices.sgml @@ -187,14 +187,15 @@ CREATE INDEX name ON table - + Hash index operations are not presently WAL-logged, so hash indexes might need to be rebuilt with REINDEX - after a database crash. - For this reason, hash index use is presently discouraged. + after a database crash. They are also not replicated over streaming or + file-based replication. + For these reasons, hash index use is presently discouraged. - + -- 2.11.0