Re: file under data

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: file under data
Дата
Msg-id 20011031152107.C19694-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на Re: file under data  ("Leong, Fushan" <fushan.leong@SonoSite.com>)
Список pgsql-admin
On Wed, 31 Oct 2001, Leong, Fushan wrote:

> delete them is bad.. but you can not let them grow forever........
>
> When and how to clean up these files?

You should VACUUM ANALYZE occasionally depending your rate of
updates and deletes on your tables.  I think you'll also need
to use REINDEX when you want to shrink the index space.  I
believe there's information about these commands in the
admin documentation.




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

Предыдущее
От: "Leong, Fushan"
Дата:
Сообщение: Re: file under data
Следующее
От: Jeremy Buchmann
Дата:
Сообщение: Re: backup file system