Re: Hash index todo list item - Mailing list pgsql-hackers

From Michael Glaesemann
Subject Re: Hash index todo list item
Date
Msg-id 113CF969-9481-4BE8-838C-41866D147163@seespotcode.net
Whole thread Raw
In response to Re: Hash index todo list item  (Mark Mielke <mark@mark.mielke.cc>)
Responses Re: Hash index todo list item
List pgsql-hackers
On Sep 6, 2007, at 10:53 , Mark Mielke wrote:

> I don't like the truncating hash suggestion because it limits the  
> ability of a hash code to uniquely identify a key.

AIUI, a hash can't be used as a unique identifier: it always needs to  
be rechecked due to the chance of collisions. There might be other  
issues with truncation, but preventing hashes from being unique isn't  
one of them.

Michael Glaesemann
grzm seespotcode net




pgsql-hackers by date:

Previous
From: Mark Mielke
Date:
Subject: Re: Hash index todo list item
Next
From: Simon Riggs
Date:
Subject: Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)