Re: extensible enum types

Tom Lane wrote:
>> Adding cache 
>> lookups for the enum rows to the comarison routines made a REINDEX on a 
>> 1m row table where the index is on an enum column (the enum has 500 
>> randomly ordered labels) jump from around 10s to around 70s.
>>     
>
> Hmmm... that's bad, but I bet it's still less than the cost of comparing
> NUMERICs.  Also, did you make any attempt to avoid repetitive cache
> lookups by storing a pointer in fn_extra (cf array comparisons)?
>
> 			
>   

No. Will work on that. Thanks.

cheers

andrew