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.2a.4bf3500b326abd8e.14cbd73f6f8@tc7-visena
Whole thread Raw
In response to Re: How to keep pg_largeobject from growing endlessly  (Adam Hooper <adam@adamhooper.com>)
Responses Re: How to keep pg_largeobject from growing endlessly
List pgsql-general
Tree view
På onsdag 15. april 2015 kl. 16:05:22, skrev Adam Hooper <adam@adamhooper.com>:
On Wed, Apr 15, 2015 at 9:57 AM, Andreas Joseph Krogh
<andreas@visena.com> wrote:
>
> På onsdag 15. april 2015 kl. 15:50:36, skrev Adam Hooper <adam@adamhooper.com>:
>
> On Wed, Apr 15, 2015 at 4:49 AM, Andreas Joseph Krogh
> <andreas@visena.com> wrote:
> >
> > In other words: Does vacuumlo cause diskspace used by pg_largeobject to be freed to the OS (after eventually vacuumed by autovacuum)?
>
> No.
>
> Ok. Out of curiousity; When does it get freed, when VACUUM FULL'ed?

Yes. VACUUM FULL or CLUSTER will free the space. (Of course, you need
a lot of free disk space to perform those operations.)
 
I'm sure there's a good reason for why VACUUM FULL needs to rewreite the whole table and cannot "just free the unused space to the OS".
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Attachment

pgsql-general by date:

Previous
From: Igor Neyman
Date:
Subject: Re: Help with slow table update
Next
From: Pawel Veselov
Date:
Subject: Re: Help with slow table update