Re: bitmap AM design

Поиск
Список
Период
Сортировка
От pgsql@mohawksoft.com
Тема Re: bitmap AM design
Дата
Msg-id 16831.24.91.171.78.1109868080.squirrel@mail.mohawksoft.com
обсуждение исходный текст
Ответ на Re: bitmap AM design  (Hannu Krosing <hannu@tm.ee>)
Список pgsql-hackers
> Ühel kenal päeval (teisipäev, 1. märts 2005, 14:54-0500), kirjutas
> pgsql@mohawksoft.com:
>> Now, it occurs to me that if my document reference table can refer to
>> something other than an indexed primary key, I can save a lot of index
>> processing time in PostgreSQL if I can have a "safe" analogy to CTID.
>
> I guess you could work on making hash indexes better (for concurrent
> access).
>
> 'a "safe" analogy to CTID' looks remarkably like hash index
>

Yes, I agree, but I don't particularly like linear hash models without the
ability to adjust the initial table size estimates. Also, hash tables
without access to the hash function typically have a lot of collision,
specifically, I am dubious of "generic" hash functions having an optimally
dispersed behavior.


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

Предыдущее
От: Joachim Wieland
Дата:
Сообщение: plperl function has side-effects
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 8.0.X and the ARC patent