Re: Large files in main/base

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Large files in main/base
Дата
Msg-id 15568.1278773686@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Large files in main/base  (Guillaume Lelarge <guillaume@lelarge.info>)
Ответы Re: Large files in main/base  ("Neuber, Dirk" <dirk.neuber@barco.com>)
Список pgsql-admin
Guillaume Lelarge <guillaume@lelarge.info> writes:
> Le 10/07/2010 12:43, Neuber, Dirk a �crit :
>>> The exact name of the file might be useful information, too.
>>
>> It is : postgres/8.3/main/base/16385/2613

> This is a system catalog, pg_largeobject, which holds binary objects. If
> you use Large Objects, no wonder this table could be really big.

Also worth noting is that there's no automatic deletion mechanism for
large objects.  It could be that the space is being eaten by LOs that
aren't referenced anymore.  If so, you should think about applying
contrib/lo and/or contrib/vacuumlo to manage your LOs.

            regards, tom lane

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: High Availability: Hot Standby vs. Warm Standby
Следующее
От: "Neuber, Dirk"
Дата:
Сообщение: Re: Large files in main/base