Re: five-key syscaches - Mailing list pgsql-hackers

From Robert Haas
Subject Re: five-key syscaches
Date
Msg-id AANLkTimCQ8SM7irTPmKSDnoRisDZ73Gp9tRoIqgmiOFv@mail.gmail.com
Whole thread Raw
In response to Re: five-key syscaches  (Yeb Havinga <yebhavinga@gmail.com>)
List pgsql-hackers
On Wed, Jul 14, 2010 at 10:56 AM, Yeb Havinga <yebhavinga@gmail.com> wrote:
> Robert Haas wrote:
>> On Wed, Jul 14, 2010 at 7:27 AM, Yeb Havinga <yebhavinga@gmail.com> wrote:
>>> Attach is a new patch with all things described above addressed.
>> Thanks!
>>
>> I think we should probably hold off applying this until some of the
>> other KNNGIST work is ready, or we have some other concrete need for
>> 5-key syscaches.
>
> Any thoughts about the << 16 and >> 16 bit shifting on the 5th hash key
> computation? I blithely copied it from the 3rd key.

Hmm, I thought I had the bit in my version, but I see that I don't.
Must have gotten lost from an earlier incarnation.  It's probably bad
to duplicate the bit-shifting pattern of an existing key.  We might
want to shift by something that's not a multiple of 8, like 12/20.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: standard_conforming_strings
Next
From: Joshua Tolley
Date:
Subject: Re: cross column correlation revisted