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
Список 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 по дате отправления: