Index: doc/src/sgml/indices.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/indices.sgml,v
retrieving revision 1.32
diff -c -r1.32 indices.sgml
*** doc/src/sgml/indices.sgml 21 Jun 2002 03:25:53 -0000 1.32
--- doc/src/sgml/indices.sgml 21 Jun 2002 16:50:23 -0000
***************
*** 181,189 ****
! 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.
--- 181,190 ----
! 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.
Index: doc/src/sgml/ref/create_index.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/ref/create_index.sgml,v
retrieving revision 1.32
diff -c -r1.32 create_index.sgml
*** doc/src/sgml/ref/create_index.sgml 21 Jun 2002 03:25:53 -0000 1.32
--- doc/src/sgml/ref/create_index.sgml 21 Jun 2002 16:50:23 -0000
***************
*** 330,338 ****
the = operator.
! 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.
--- 330,339 ----
the = operator.
! 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.