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 528612A6.2020407@vmware.com
Whole thread Raw
In response to Re: init_sequence spill to hash table  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
On 15.11.2013 12:44, Andres Freund wrote:
> On 2013-11-15 12:31:54 +0200, Heikki Linnakangas wrote:
>> On 15.11.2013 07:47, David Rowley wrote:
>>> On Fri, Nov 15, 2013 at 3:03 AM, Heikki Linnakangas <hlinnakangas@vmware.com
>>>> wrote
>>>>
>>>> I think that means that we should just completely replace the list with
>>>> the hash table. The difference with a small N is lost in noise, so there's
>>>> no point in keeping the list as a fast path for small N. That'll make the
>>>> patch somewhat simpler.
>>>
>>> Attached is a much more simple patch which gets rid of the initial linked
>>> list.
>>
>> Thanks, committed with minor copy-editing. I dialed down the initial size of
>> the hash table from 1000 to 16, that ought to be enough.
>
> I am slightly confused by the use of HASH_CONTEXT without setting
> ctl->hcxt, that works, but seems more like an accident.

Ugh. Accident indeed. Thanks, fixed!

- Heikki



pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: Proof of concept: standalone backend with full FE/BE protocol
Next
From: Simon Riggs
Date:
Subject: Re: Proof of concept: standalone backend with full FE/BE protocol