Re: WIP: extensible enums - Mailing list pgsql-hackers

From Tom Lane
Subject Re: WIP: extensible enums
Date
Msg-id 22977.1287425317@sss.pgh.pa.us
Whole thread Raw
In response to Re: WIP: extensible enums  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> If you have want to work on it and prove it's going to be better, please 
> do. I'm not convinced it will do a whole lot better than a binary search 
> that in most cases will do no more than a handful of probes.

Yeah, that's a good point.  There's a range of table sizes where hashing
is faster than binary search, but I'm not sure that typical enums will
fall into that range.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Floating-point timestamps versus Range Types
Next
From: Bruce Momjian
Date:
Subject: Re: create tablespace fails silently, or succeeds improperly