Postgres Pro
Downloads
Home   >   mailing lists

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

From Andreas Joseph Krogh
Subject Re: How to keep pg_largeobject from growing endlessly
Date
Msg-id VisenaEmail.10.be5cc5fce33413df.14cbc43281a@tc7-visena
Whole thread Raw
In response to Re: How to keep pg_largeobject from growing endlessly  (Venkata Balaji N <nag1010@gmail.com>)
Responses Re: How to keep pg_largeobject from growing endlessly
List pgsql-general
Tree view
På onsdag 15. april 2015 kl. 04:43:47, skrev Venkata Balaji N <nag1010@gmail.com>:
 
I'm routinely vacuumlo'ing to reap orphan OIDs. Is it necessary to manually vacuum pg_largobject or is it handled by autovacuum?
 
 
It is handled by autovacuum. What we do is, we schedule a manual VACUUM ANALYZE nightly job on bigger tables to avoid burden on the autovacuum during the business time.
 
 
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?
 
 
The amount of reclaimed space will depend on the volume of deletions happening. If the DELETES are rare and are not deleting much, then frequent VACUUM FULL is not ideal.
 
In other words: Does vacuumlo cause diskspace used by pg_largeobject to be freed to the OS (after eventually vacuumed by autovacuum)?
 
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: Re: Where does vacuum FULL write temp-files?
Next
From: Adam Hooper
Date:
Subject: Re: How to keep pg_largeobject from growing endlessly