Re: Avoiding unnecessary clog lookups while freezing

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Avoiding unnecessary clog lookups while freezing
Дата
Msg-id 577388.1672334703@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Avoiding unnecessary clog lookups while freezing  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> Somewhat of a tangent: I've previously wondered if we should have a small
> hash-table based clog cache. The current one-element cache doesn't suffice in
> a lot of scenarios, but it wouldn't take a huge cache to end up filtering most
> clog accesses.

I've wondered about that too.  The one-element cache was a good hack
in its day, but it looks a bit under-engineered by our current
standards.  (Also, maybe it'd be plausible to have a one-element
cache in front of a small hash?)

            regards, tom lane



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

Предыдущее
От: Matthias van de Meent
Дата:
Сообщение: Re: split TOAST support out of postgres.h
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Avoiding unnecessary clog lookups while freezing