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 <[EMAIL PROTECTED]> 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 sayNote: 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 |
- Re: [HACKERS] todo: Hash index creation Naz Gassiep
- Re: [HACKERS] todo: Hash index creation Heikki Linnakangas
- Re: [HACKERS] todo: Hash index creation Kenneth Marshall