Re: Protect syscache from bloating with negative cache entries

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Protect syscache from bloating with negative cache entries
Дата
Msg-id 20190218134956.GA909@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: Protect syscache from bloating with negative cache entries  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-hackers
On 2019-Feb-15, Tomas Vondra wrote:

> ISTM there's a couple of ways to deal with that:
> 
> 1) Ignore the memory amounts entirely, and do just time-base eviction.
> 
> 2) If we want some size thresholds (e.g. to disable eviction for
> backends with small caches etc.) use the number of entries instead. I
> don't think that's particularly worse that specifying size in MB.

Why is there a *need* for size-based eviction?  Seems that time-based
should be sufficient.  Is the proposed approach to avoid eviction at all
until the size threshold has been reached?  I'm not sure I see the point
of that.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Incorrect visibility test function assigned to snapshot
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Ryu floating point output patch