Re: large objects & space usage

Поиск
Список
Период
Сортировка
От David Wall
Тема Re: large objects & space usage
Дата
Msg-id 478AB3B4.1090600@computer.org
обсуждение исходный текст
Ответ на Re: large objects & space usage  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: large objects & space usage  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
> If there are no other tables storing large objects in the database,
> dropping and reloading the whole database is probably the simplest
> solution.  Otherwise they're going to need to make sure the unwanted
> LOs have been cleaned out (see contrib/vacuumlo) and then do a VACUUM
> FULL or similar on pg_largeobject.
>
Does the psql command 'vacuum;' by itself automatically vacuum
pg_largeobject along with all of tables in the database?

David


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

Предыдущее
От: "Vishal Mailinglist"
Дата:
Сообщение: Re: Need some info.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: large objects & space usage