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

From Tom Lane
Subject Re: Hash index todo list item
Date
Msg-id 21432.1189085898@sss.pgh.pa.us
Whole thread Raw
In response to Re: Hash index todo list item  (Hannu Krosing <hannu@skype.net>)
Responses Re: Hash index todo list item
List pgsql-hackers
Hannu Krosing <hannu@skype.net> writes:
> Ühel kenal päeval, E, 2007-09-03 kell 19:55, kirjutas Tom Lane:
>> No, because part of the deal is that you can do lookups using only the
>> leading index columns.  At least, all the existing multicolumn index
>> types can do that.

> One approahc is not to mix hashes, but to partition the hash, so that
> each column gets its N bits in the hash. 

How does that help?  You still need all the keys to find out which
bucket to look in.
        regards, tom lane


pgsql-hackers by date:

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