Re: A better way than tweaking NTUP_PER_BUCKET

Поиск
Список
Период
Сортировка
От Atri Sharma
Тема Re: A better way than tweaking NTUP_PER_BUCKET
Дата
Msg-id CAOeZVif_hbmZ0yThvqwR=SoDrnedVE=jqjX209NqrTUFraikyg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: A better way than tweaking NTUP_PER_BUCKET  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: A better way than tweaking NTUP_PER_BUCKET  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
Hi all,

I have been working on a patch for the above discussed
functionalities. I made an array of int32s, one for each bucket in a
hash table(the array is per hash table).

I am using the hash value directly to set the corresponding bit in the
bit field.Specifically:

bitfield_orvalue = 1<<hashvalue;
hashtable->bitFields[bucketNumber] =
(hashtable->bitFields[bucketNumber]) |bitfield_orvalue;

But,the hash values are way beyond this, and I admit that my choice of
int32 as bitfield isn't correct here.

The hash values are like:

13599104251359910425-1662820951-1662820951

What should I be using for the bit map?

Regards,

Atri

--
Regards,

Atri
l'apprenant



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: Reduce maximum error in tuples estimation after vacuum.
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: [PATCH] Add an ldapoption to disable chasing LDAP referrals