diff options
| -rw-r--r-- | doc/src/sgml/indices.sgml | 9 | ||||
| -rw-r--r-- | doc/src/sgml/ref/create_index.sgml | 9 |
2 files changed, 10 insertions, 8 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> 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> |