Re: Hash index use presently(?) discouraged since 2005: revive or bury it? - Mailing list pgsql-performance

From Stefan Keller
Subject Re: Hash index use presently(?) discouraged since 2005: revive or bury it?
Date
Msg-id CAFcOn2_T1iP=VyGL4Cn-wW0zN-CoS+zjjiSK_QUVj8tarM2DKQ@mail.gmail.com
Whole thread Raw
In response to Re: Hash index use presently(?) discouraged since 2005: revive or bury it?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
2011/9/16 Tom Lane <tgl@sss.pgh.pa.us>:
> I'm not entirely following this eagerness to junk that AM, anyway.
> We've put a lot of sweat into it over the years, in the hopes that
> it would eventually be good for something.  It's on the edge of
> being good for something now, and there's doubtless room for more
> improvements, so why are the knives out?

No knives from my side. Sorry for the exaggerated subject title.
I'm also in favor for an enhanced hash index for cases where only "="
tests are processed and where only few inserts/deletes will occur.

Stefan

pgsql-performance by date:

Previous
From: Claudio Freire
Date:
Subject: Odd misprediction
Next
From: Tomas Vondra
Date:
Subject: Re: Hash index use presently(?) discouraged since 2005: revive or bury it?