hash taboo?

From: admin <admin(at)wtbwts(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: hash taboo?
Date: 1999-12-17 22:17:03
Message-ID: Pine.BSF.4.10.9912172211140.8286-100000@server.b0x.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've been reading the postgresql manual and I find there is very little
discussion about hash compared to btree. Most of the focus seems to be on
using btree indices even that the default for 'create index' is btree
also. From the documentation, it seems the only difference between either
searching method is that btree can be used with multiple operators whilst
hash can only be used with '='. Furthermore, hash seems to be contained in
memory, so should be limited to small queries or, in my case, queries
using limit (without using sort which would need to retrieve the entire
data anyways).

My conclusion is that if I can live with just using '=' and using slightly
more memory, I should be using hash. Unfortunately, there is very little
sign in the documentation that I should be using hash at all. Perhaps I
have missed something important.

If someone could help me make a more rational decision on using searching
methods, I'd appreciate.

Thanks in advance,
Marc

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ed Loehr 1999-12-17 22:20:40 Re: [GENERAL] How to get timestamped pgsql logging?
Previous Message Karl DeBisschop 1999-12-17 21:38:54 Re: [BUGS] problem creating index in 6,5,3