How to keep pg_largeobject from growing endlessly

Поиск
Список
Период
Сортировка
От Andreas Joseph Krogh
Тема How to keep pg_largeobject from growing endlessly
Дата
Msg-id VisenaEmail.6.2c56f1d820d62844.14cbaccc708@tc7-visena
обсуждение исходный текст
Ответы Re: How to keep pg_largeobject from growing endlessly  (Venkata Balaji N <nag1010@gmail.com>)
Список pgsql-general
Hi all
 
I'm routinely vacuumlo'ing to reap orphan OIDs. Is it necessary to manually vacuum pg_largobject or is it handled by autovacuum?
 
In a system where large objects are constantly added (and *some* rarely deleted, so it grows every day), would I gain space (freed to the OS) by VACUUM FULL it?
 
Thanks.
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
Вложения

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

Предыдущее
От: Andreas Joseph Krogh
Дата:
Сообщение: Where does vacuum FULL write temp-files?
Следующее
От: Venkata Balaji N
Дата:
Сообщение: Re: Where does vacuum FULL write temp-files?