Re: Hash indexes

On Tue, Dec 15, 2009 at 11:48 AM, Mladen Gogala
<mladen.gogala@vmsinfo.com> wrote:

> My question is whether someone here has played with the hash indexes? Any
> words of caution or blissful experiences? Thanks.

I can't give experiences either way, but I've remember reading a post
to the pg_general mailing regarding this subject a couple of years
ago.  Basically the advice was, since there the performance
differences between B-tree and Hash are negligible, why bother using
Hash indexes.

I cant find the post, but here is one that is a little more recent:

http://archives.postgresql.org/pgsql-hackers/2009-10/msg00284.php

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug