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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
