delete/vacuum not freeing disk space

Поиск
Список
Период
Сортировка
От Joshua Franklin
Тема delete/vacuum not freeing disk space
Дата
Msg-id 20011006165604.72133.qmail@web20005.mail.yahoo.com
обсуждение исходный текст
Список pgsql-admin
I've got a large database that's getting too big. I
checked with the users and deleted approximately 1/6th
of the records (we have archived backups) and then ran
a VACUUM, which took a really long time to complete
(several days). But, the disk space usage doesn't seem
to have changed. Do I need to VACUUM twice or
something? Should it be faster the second time?

Thanks.

__________________________________________________
Do You Yahoo!?
NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1

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

Предыдущее
От: "Pedro Fonseca"
Дата:
Сообщение: Re: Authorization problem
Следующее
От: Russ McBride
Дата:
Сообщение: Mac OS X installation web page