Re: init_sequence spill to hash table

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: init_sequence spill to hash table
Дата
Msg-id 52835F54.5020404@vmware.com
обсуждение исходный текст
Ответ на init_sequence spill to hash table  (David Rowley <dgrowleyml@gmail.com>)
Ответы Re: init_sequence spill to hash table  (David Rowley <dgrowleyml@gmail.com>)
Список pgsql-hackers
On 13.11.2013 11:55, David Rowley wrote:
> I thought I would post the patch early to see if this is actually wanted
> before I do too much more work on it.

Seems reasonable.

> My implementation maintains using the linear list for sequences up to a
> defined threshold (currently 32) then it moves everything over to a
> hashtable and free's off the list.

Did you check how it would perform if you just always used the hash 
table? Or if you just have a single entry before you move to hash table, 
ie. set the threshold to 2? That would be slightly simpler.

- Heikki



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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Fast insertion indexes: why no developments
Следующее
От: Luca Ferrari
Дата:
Сообщение: Re: [OT] why not keeping the original column name in catalog after a drop?