Skip site navigation (1) Skip section navigation (2)

Re: Hash indexes

From: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
To: mladen(dot)gogala(at)vmsinfo(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Hash indexes
Date: 2009-12-15 21:02:11
Message-ID: 396486430912151302q47febd38x612d6b3569c12089@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Tue, Dec 15, 2009 at 11:48 AM, Mladen Gogala
<mladen(dot)gogala(at)vmsinfo(dot)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

In response to

pgsql-novice by date

Next:From: Jasen BettsDate: 2009-12-16 11:59:04
Subject: Re: UTC timestamp
Previous:From: Mladen GogalaDate: 2009-12-15 19:48:18
Subject: Hash indexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group