I had submitted the documentation change as part of my hash function patch but it was removed as not relevant. (It wasn't really.) I would basically remove the first sentence:
Note: Hash index operations are not presently WAL-logged, so hash indexes might need to be rebuilt with REINDEX after a database crash. For this reason, hash index use is presently discouraged. Ken On Wed, Feb 04, 2009 at 01:22:23PM -0300, Alvaro Herrera wrote: > Hi, > > indices.sgml contains this paragraph about hash indexes: > > Note: Testing has shown PostgreSQL's hash indexes to perform no > better than B-tree indexes, and the index size and build time for hash > indexes is much worse. Furthermore, hash index operations are not > presently WAL-logged, so hash indexes might need to be rebuilt with > REINDEX after a database crash. For these reasons, hash index use is > presently discouraged. > > > However, it seems to me that hash indexes are much improved in 8.4, so > maybe this needs to be reworded. I'm not sure to what point they have > been improved though. > > -- > Alvaro Herrera http://www.CommandPrompt.com/ > PostgreSQL Replication, Consulting, Custom Development, 24x7 support > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers