Re: WIP: extensible enums
От | Andrew Dunstan |
---|---|
Тема | Re: WIP: extensible enums |
Дата | |
Msg-id | 4CBB4F05.2050601@dunslane.net обсуждение исходный текст |
Ответ на | Re: WIP: extensible enums (Dean Rasheed <dean.a.rasheed@gmail.com>) |
Ответы |
Re: WIP: extensible enums
|
Список | pgsql-hackers |
On 10/17/2010 02:19 PM, Dean Rasheed wrote: > That makes me think maybe the "fast" and "slow" comparisons should > both be done the same way, having a cache so that we notice > immediately if we get a new value. > > Obviously that's not going to be as fast as the current "fast" method, > but the question is, can it be made sufficiently close? I think the > current sort+bsearch method is always going to be significantly > slower, but perhaps a dedicated hash table algorithm might work. > Making that as fast as "Is this sorted? If yes, compare the two oids" or even acceptably slower seems likely to be a challenge. I thought about the sort of approach you suggest initially and didn't come up with anything that seemed likely to work well enough. cheers andrew
В списке pgsql-hackers по дате отправления: