diff options
| author | Bruce Momjian <bruce@momjian.us> | 2009-02-07 20:05:44 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2009-02-07 20:05:44 +0000 |
| commit | 97072ad80c406e58b04d15204941889bf29d9c83 (patch) | |
| tree | 28b2dfd8a472f0ea3ed4889b24d8c678305aa9cb | |
| parent | 0c0d65203166ab5fe82cb7999bcfeae2c56141ee (diff) | |
| download | postgresql-97072ad80c406e58b04d15204941889bf29d9c83.tar.gz postgresql-97072ad80c406e58b04d15204941889bf29d9c83.zip | |
Remove documentation mention that hash indexes perform no better than
btree; keep mention about missing WAL logging.
Kenneth Marshall
| -rw-r--r-- | doc/src/sgml/indices.sgml | 9 |
1 files changed, 3 insertions, 6 deletions
diff --git a/doc/src/sgml/indices.sgml b/doc/src/sgml/indices.sgml index 0993a8be03f..d3d1baed243 100644 --- a/doc/src/sgml/indices.sgml +++ b/doc/src/sgml/indices.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/indices.sgml,v 1.75 2008/09/23 09:20:34 heikki Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/indices.sgml,v 1.76 2009/02/07 20:05:44 momjian Exp $ --> <chapter id="indexes"> <title id="indexes-title">Indexes</title> @@ -190,13 +190,10 @@ CREATE INDEX <replaceable>name</replaceable> ON <replaceable>table</replaceable> <note> <para> - Testing has shown <productname>PostgreSQL</productname>'s hash - indexes to perform no better than B-tree indexes, and the - index size and build time for hash indexes is much worse. - Furthermore, hash index operations are not presently WAL-logged, + Hash index operations are not presently WAL-logged, so hash indexes might need to be rebuilt with <command>REINDEX</> after a database crash. - For these reasons, hash index use is presently discouraged. + For this reason, hash index use is presently discouraged. </para> </note> |