Re: WIP: extensible enums

On 10/24/2010 05:34 PM, Tom Lane wrote:
> BTW, I've forgotten --- did anyone publish a test case for checking
> performance of enum comparisons?  Or should I just cons up something
> privately?
>

I have been running tests with 
<http://developer.postgresql.org/~adunstan/enumtest.dmp>

The table "mydata" contains 100k rows with the column "label" containing 
random values of an enum type with 500 labels. Basically, my main test 
is to set up an index on that column. The alter the enum type, and test 
again. Then alter some of the rows, and test again.


cheers

andrew