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.