Re: SearchCatCacheList()/SearchSysCacheList() is O(n)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: SearchCatCacheList()/SearchSysCacheList() is O(n)
Дата
Msg-id 1343982.1620854788@sss.pgh.pa.us
обсуждение исходный текст
Ответ на SearchCatCacheList()/SearchSysCacheList() is O(n)  (Andres Freund <andres@anarazel.de>)
Ответы Re: SearchCatCacheList()/SearchSysCacheList() is O(n)  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> The problem is that SearchCatCacheList() is not actually a hash table -
> there are no buckets, in contrast to SearchCatCacheList().

Uh, what did you mean to compare to there?

> Tom, any chance you remember if this was an oversight, or whether you
> just considered this to be OK, given the likely numbers of objects?

I'm pretty sure I didn't think the lists would get large enough to be
a problem.  I'm not quite sure which list is a problem here, actually,
seeing that the functions all have distinct names.

I have a vague recollection that some callers depend on the lists
being ordered by key.  I'm also fairly sure that most callers need
to look at all entries of whichever list they've requested.  So
I have doubts that "use a hash table" is really going to be a
productive idea.

            regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: SearchCatCacheList()/SearchSysCacheList() is O(n)
Следующее
От: Andres Freund
Дата:
Сообщение: Re: SearchCatCacheList()/SearchSysCacheList() is O(n)