aboutsummaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/create_index.sgml
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2002-06-21 16:52:00 +0000
committerBruce Momjian <bruce@momjian.us>2002-06-21 16:52:00 +0000
commit1415a8388f2912ea4618a4eeaf40ed11fa808bdc (patch)
tree385577ec2d90f628152c77b6f2823bcb9285edf0 /doc/src/sgml/ref/create_index.sgml
parentebe4375fa1d875ff51dbc127f3317d281b21589d (diff)
downloadpostgresql-1415a8388f2912ea4618a4eeaf40ed11fa808bdc.tar.gz
postgresql-1415a8388f2912ea4618a4eeaf40ed11fa808bdc.zip
Update hash warning in manual.
Diffstat (limited to 'doc/src/sgml/ref/create_index.sgml')
-rw-r--r--doc/src/sgml/ref/create_index.sgml9
1 files changed, 5 insertions, 4 deletions
diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml
index 6bb972e988e..62963c21724 100644
--- a/doc/src/sgml/ref/create_index.sgml
+++ b/doc/src/sgml/ref/create_index.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_index.sgml,v 1.32 2002/06/21 03:25:53 momjian Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_index.sgml,v 1.33 2002/06/21 16:52:00 momjian Exp $
PostgreSQL documentation
-->
@@ -330,9 +330,10 @@ ERROR: Cannot create index: 'index_name' already exists.
the <literal>=</literal> operator.
</para>
<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>
<para>