diff options
Diffstat (limited to 'doc/src/sgml/indices.sgml')
| -rw-r--r-- | doc/src/sgml/indices.sgml | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/doc/src/sgml/indices.sgml b/doc/src/sgml/indices.sgml index 6317e4ea749..214764a4a6c 100644 --- a/doc/src/sgml/indices.sgml +++ b/doc/src/sgml/indices.sgml @@ -1,4 +1,4 @@ -<!-- $Header: /cvsroot/pgsql/doc/src/sgml/indices.sgml,v 1.32 2002/06/21 03:25:53 momjian Exp $ --> +<!-- $Header: /cvsroot/pgsql/doc/src/sgml/indices.sgml,v 1.33 2002/06/21 16:52:00 momjian Exp $ --> <chapter id="indexes"> <title id="indexes-title">Indexes</title> @@ -181,9 +181,10 @@ CREATE INDEX <replaceable>name</replaceable> ON <replaceable>table</replaceable> </synopsis> <note> <para> - Testing has shown that hash indexes are slower than btree indexes, - and the size and build time for hash indexes is much worse. For - these reasons, hash index use is discouraged. + Testing has shown hash indexes to be similar or slower than btree + indexes, and the index size and build time for hash indexes is much + worse. Hash indexes also suffer poor performance under high + concurrency. For these reasons, hash index use is discouraged. </para> </note> </para> |