| From: | Adam Hooper <adam(at)adamhooper(dot)com> |
|---|---|
| To: | Andreas Joseph Krogh <andreas(at)visena(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How to keep pg_largeobject from growing endlessly |
| Date: | 2015-04-15 14:05:22 |
| Message-ID: | CAMWjz6HUbx7E76KFeP7HPn_+GNrbykYSaz_2sj2pCVZXuHg_3g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Apr 15, 2015 at 9:57 AM, Andreas Joseph Krogh
<andreas(at)visena(dot)com> wrote:
>
> På onsdag 15. april 2015 kl. 15:50:36, skrev Adam Hooper <adam(at)adamhooper(dot)com>:
>
> On Wed, Apr 15, 2015 at 4:49 AM, Andreas Joseph Krogh
> <andreas(at)visena(dot)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.)
Enjoy life,
Adam
--
Adam Hooper
+1-613-986-3339
http://adamhooper.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igor Neyman | 2015-04-15 14:14:10 | Re: Help with slow table update |
| Previous Message | Andreas Joseph Krogh | 2015-04-15 13:57:01 | Re: How to keep pg_largeobject from growing endlessly |