Re: Reducing overhead for repeat de-TOASTing

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Reducing overhead for repeat de-TOASTing
Дата
Msg-id 3446.1213727463@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Reducing overhead for repeat de-TOASTing  (Teodor Sigaev <teodor@sigaev.ru>)
Список pgsql-hackers
Teodor Sigaev <teodor@sigaev.ru> writes:
>> But we can resolve that by ruling that the required lifetime is the same
>> as the value would have had if it'd really been palloc'd --- IOW, until
>> the memory context that was current at the time gets deleted or reset.

> Many support functions of GiST/GIN live in very short memory context - only for 
> one call. So, that cache invalidation technique doesn't give any advantage 
> without rearranging this part.

Right, but I think I've got that covered.  The memory context reset
won't actually flush the toast cache entry, it effectively just drops its
reference count.  We'll only drop cache entries when under memory
pressure (or if they're invalidated by toast table updates/deletes).
        regards, tom lane


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

Предыдущее
От: Teodor Sigaev
Дата:
Сообщение: Re: Reducing overhead for repeat de-TOASTing
Следующее
От: Kenneth Marshall
Дата:
Сообщение: Re: Cleaning up cross-type arithmetic operators