Re: HASH: Out of overflow pages. Out of luck - Mailing list pgsql-hackers

From nconway@klamath.dyndns.org (Neil Conway)
Subject Re: HASH: Out of overflow pages. Out of luck
Date
Msg-id 20020807144658.GA14126@klamath.dyndns.org
Whole thread Raw
In response to Re: HASH: Out of overflow pages. Out of luck  (selkovjr@xnet.com)
List pgsql-hackers
On Wed, Aug 07, 2002 at 12:41:04AM -0500, selkovjr@xnet.com wrote:
> Some of the data structures resemble each other's counterparts;
> the only piece that is exactly the same as one of the five
> BerkelyDB's hash functions. 

FYI, the development version of PostgreSQL uses a completely
different (and higher quality) hash function.

> The only useful experiment that I feel I am capable of making is
> trying their __ham_hash5() function, with they claim is generally
> better than the other four, for most purposes.

I'm skeptical that changing the hash function would make a significant
difference to the usability of hash indexes. At the very least, the
reproducible deadlocks under concurrent access need to be fixed, as well
as a host of other issues.

Cheers,

Neil

-- 
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC


pgsql-hackers by date:

Previous
From: Lamar Owen
Date:
Subject: Re: Open 7.3 items
Next
From: Tatsuo Ishii
Date:
Subject: Re: Off-topic: FUNC_MAX_ARGS benchmarks