Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Geoghegan
Subject Re: Hash index use presently(?) discouraged since 2005: revive or bury it?
Date
Msg-id CAEYLb_Udue8_XSE9K0KMqKBE_62yurv1bY4Wc+qJoGykZ_rXtA@mail.gmail.com
Whole thread Raw
In response to Hash index use presently(?) discouraged since 2005: revive or bury it?  (Stefan Keller <sfkeller@gmail.com>)
Responses Re: Hash index use presently(?) discouraged since 2005: revive or bury it?
Re: Hash index use presently(?) discouraged since 2005: revive or bury it?
List pgsql-performance
Tree view 
On 14 September 2011 00:04, Stefan Keller <sfkeller@gmail.com> wrote:
> Has this been verified on a recent release? I can't believe that hash
> performs so bad over all these points. Theory tells me otherwise and
> http://en.wikipedia.org/wiki/Hash_table seems to be a success.

Hash indexes have been improved since 2005 - their performance was
improved quite a bit in 9.0. Here's a more recent analysis:

http://www.depesz.com/index.php/2010/06/28/should-you-use-hash-index/

--
Peter Geoghegan       http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services

pgsql-performance by date:

Previous
From: Samuel Gendler
Date:
Subject: Re: raid array seek performance
Next
From: Tom Lane
Date:
Subject: Re: Hash index use presently(?) discouraged since 2005: revive or bury it?