Wow... not sure how I missed that. I *did* create this schema ages ago, perhaps it wasn't there, or at the time I had no idea what the implications were. *shrug*
Regards,
- Naz.


Tom Lane wrote:
Naz Gassiep <naz@mira.net> writes:
  
As a result, when creating tables containing large blocks of text I wish
to index, I've been using HASH as an index method. Please can we state
in the manual that HASH index types are in a beta stage of development
or something similar, or perhaps remove the manual entry altogether
until HASH is at a point where it is usable in production.
    

Uh, the manual already does say

    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.

under 11.2 Index Types, as well as various derogatory remarks elsewhere.

			regards, tom lane