How to keep pg_largeobject from growing endlessly - Mailing list pgsql-general

From Andreas Joseph Krogh
Subject How to keep pg_largeobject from growing endlessly
Date
Msg-id VisenaEmail.6.2c56f1d820d62844.14cbaccc708@tc7-visena
Whole thread Raw
Responses Re: How to keep pg_largeobject from growing endlessly  (Venkata Balaji N <nag1010@gmail.com>)
List 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
Attachment

pgsql-general by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Where does vacuum FULL write temp-files?
Next
From: Venkata Balaji N
Date:
Subject: Re: Where does vacuum FULL write temp-files?