Skip to content

Commit 97072ad

Browse files
committed
Remove documentation mention that hash indexes perform no better than
btree; keep mention about missing WAL logging. Kenneth Marshall
1 parent 0c0d652 commit 97072ad

File tree

1 file changed

+3
-6
lines changed

1 file changed

+3
-6
lines changed

doc/src/sgml/indices.sgml

+3-6
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $PostgreSQL: pgsql/doc/src/sgml/indices.sgml,v 1.75 2008/09/23 09:20:34 heikki Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/indices.sgml,v 1.76 2009/02/07 20:05:44 momjian Exp $ -->
22

33
<chapter id="indexes">
44
<title id="indexes-title">Indexes</title>
@@ -190,13 +190,10 @@ CREATE INDEX <replaceable>name</replaceable> ON <replaceable>table</replaceable>
190190

191191
<note>
192192
<para>
193-
Testing has shown <productname>PostgreSQL</productname>'s hash
194-
indexes to perform no better than B-tree indexes, and the
195-
index size and build time for hash indexes is much worse.
196-
Furthermore, hash index operations are not presently WAL-logged,
193+
Hash index operations are not presently WAL-logged,
197194
so hash indexes might need to be rebuilt with <command>REINDEX</>
198195
after a database crash.
199-
For these reasons, hash index use is presently discouraged.
196+
For this reason, hash index use is presently discouraged.
200197
</para>
201198
</note>
202199

0 commit comments

Comments
 (0)