Adrian Klaver <aklaver@xxxxxxxxxxx> writes: > On Thursday 17 December 2009 6:39:45 pm CG wrote: >> CREATE INDEX packet_search_trigram_packet_uuid_idx >> ON dpo.packet_search_trigram >> USING hash >> (packet_uuid); > You might want to take a look at upgrading to 8.4.2 per this from the release > notes: Actually, what I'd recommend is dropping that hash index and replacing it with regular btree. And the same for any other hash indexes you have. Hash indexes simply are not production grade (yet). regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
