How to keep pg_largeobject from growing endlessly

From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: How to keep pg_largeobject from growing endlessly
Date: 2015-04-15 02:03:38
Message-ID: VisenaEmail.6.2c56f1d820d62844.14cbaccc708@tc7-visena
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com> www.visena.com
<https://www.visena.com> <https://www.visena.com>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Venkata Balaji N 2015-04-15 02:34:31 Re: Where does vacuum FULL write temp-files?
Previous Message Andreas Joseph Krogh 2015-04-15 01:09:31 Where does vacuum FULL write temp-files?