postgres.git / summary / log / commit / refs

commit    8ae503a5bee27959bcb063785d3dd25cb4966eca
Author:   Simon Riggs <simon@2ndQuadrant.com>
Date:     Wed Oct 17 07:35:39 2012 +0000
First released in: 8.3.22, 8.4.15

    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 5104a656e9e..400450460de 100644
--- a/doc/src/sgml/ref/create_index.sgml
+++ b/doc/src/sgml/ref/create_index.sgml
@@ -428,6 +428,18 @@ Indexes:
    they can be useful.
   </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>
    Currently, only the B-tree, GiST and GIN index methods support
    multicolumn indexes. Up to 32 fields can be specified by default.


[parent: 6d934e4aaec1]