Re: How to keep pg_largeobject from growing endlessly

Поиск
Список
Период
Сортировка
От Adam Hooper
Тема Re: How to keep pg_largeobject from growing endlessly
Дата
Msg-id CAMWjz6HUbx7E76KFeP7HPn_+GNrbykYSaz_2sj2pCVZXuHg_3g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to keep pg_largeobject from growing endlessly  (Andreas Joseph Krogh <andreas@visena.com>)
Ответы Re: How to keep pg_largeobject from growing endlessly  (Andreas Joseph Krogh <andreas@visena.com>)
Список pgsql-general
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
vacuumedby 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Andreas Joseph Krogh
Дата:
Сообщение: Re: How to keep pg_largeobject from growing endlessly
Следующее
От: Igor Neyman
Дата:
Сообщение: Re: Help with slow table update