Re: Protect syscache from bloating with negative cache entries

Поиск
Список
Период
Сортировка
От MauMau
Тема Re: Protect syscache from bloating with negative cache entries
Дата
Msg-id 7BB6D08FB81C4690BC01741E6B7B1692@tunaPC
обсуждение исходный текст
Ответ на Re: Protect syscache from bloating with negative cache entries  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
From: Alvaro Herrera
> I think seqscanning the hash table is going to be too slow;
Ideriha-san
> idea of having a dlist with the entries in LRU order (where each
entry
> is moved to head of list when it is touched) seemed good: it allows
you
> to evict older ones when the time comes, without having to scan the
rest
> of the entries.  Having a dlist means two more pointers on each
cache
> entry AFAIR, so it's not a huge amount of memory.

Absolutely.  We should try to avoid unpredictable long response time
caused by an occasional unlucky batch processing.  That makes the
troubleshooting when the user asks why they experience unsteady
response time.

Regards
MauMau







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

Предыдущее
От: Raúl Marín
Дата:
Сообщение: Re: [PATCH] pgbench tap tests fail if the path contains a perl special character
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ON SELECT rule on a table without columns