Re: init_sequence spill to hash table - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: init_sequence spill to hash table
Date
Msg-id 52835F54.5020404@vmware.com
Whole thread Raw
In response to init_sequence spill to hash table  (David Rowley <dgrowleyml@gmail.com>)
Responses Re: init_sequence spill to hash table  (David Rowley <dgrowleyml@gmail.com>)
List 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 by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Fast insertion indexes: why no developments
Next
From: Luca Ferrari
Date:
Subject: Re: [OT] why not keeping the original column name in catalog after a drop?