From 6166c7301ed9286c1e2af2f83a39e8b8225338bf Mon Sep 17 00:00:00 2001
From: Simon Riggs <simon@2ndQuadrant.com>
Date: Wed, 17 Oct 2012 08:36:45 +0100
Subject: [PATCH] Add hash index caution to CREATE INDEX docs

---
 doc/src/sgml/ref/create_index.sgml | 12 ++++++++++++
 1 file changed, 12 insertions(+)

diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml
index 7686700d78..81e927c05a 100644
--- a/doc/src/sgml/ref/create_index.sgml
+++ b/doc/src/sgml/ref/create_index.sgml
@@ -467,6 +467,18 @@ CREATE INDEX lower_title_idx ON films ((lower(title)));
 </programlisting>
   </para>
 
+  <caution>
+   <para>
+    Hash index operations are not presently WAL-logged,
+    so hash indexes might need to be rebuilt with <command>REINDEX</>
+    after a database crash if there were unwritten changes.
+    Also, changes to hash indexes are not replicated over warm standby
+    replication after the initial base backup, so they
+    give wrong anwers to queries that subsequently use them.
+    For these reasons, hash index use is presently discouraged.
+   </para>
+  </caution>
+
   <para>
    To create an index with non-default sort ordering of nulls:
 <programlisting>
-- 
2.50.0