Why vacuum_index_cleanup is needed for TOAST relations?

Поиск
Список
Период
Сортировка
От Nikolay Shaplov
Тема Why vacuum_index_cleanup is needed for TOAST relations?
Дата
Msg-id 1913777.Tu8UlikUOK@x200m
обсуждение исходный текст
Ответы Re: Why vacuum_index_cleanup is needed for TOAST relations?  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-hackers
I am importing recent changes into my reloption patch and came to a question, 
I did not find an answer...

vacuum_index_cleanup option exists for both heap and toast relations.

As I understand from documentation index cleanup is about is about reporting 
access method that some tuples in table that were indexed are dead, and should 
be cleaned.

And as far as I get, we do not index any TOAST tuples directly. They are 
obtained by getting relation tuple, and then deTOAST it.

So I do not understand why do we need vacuum_index_cleanup for TOAST tables. 
May be we should remove it from there??

Or if I am wrong, can you explain where it is needed?


-- 
Software Developer: https://www.upwork.com/freelancers/~014a87e140ff02c0da
Body-oriented Therapist: https://vk.com/nataraj_rebalancing  (Russian)



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

Предыдущее
От: Stas Kelvich
Дата:
Сообщение: Re: Add client connection check during the execution of the query
Следующее
От: Alexander Lakhin
Дата:
Сообщение: Re: make installcheck-world in a clean environment