Re: How long - Vacumm full - 10 million to 90,000

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: How long - Vacumm full - 10 million to 90,000
Дата
Msg-id 20080529162215.GT40070@commandprompt.com
обсуждение исходный текст
Ответ на How long - Vacumm full - 10 million to 90,000  (Emi Lu <emilu@encs.concordia.ca>)
Список pgsql-sql
On Thu, May 29, 2008 at 11:33:36AM -0400, Emi Lu wrote:

> I have a table from around 10 million to 90,000, after deletion, I tried to 
> use vacuum full, but it seems that it takes forever to finish. Could anyone 
> tell me how long it will take to finish the Recovering disk space please?

A really really long time.  You might actually be better off to dump
the table and restore it from that.

A

-- 
Andrew Sullivan
ajs@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/


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

Предыдущее
От: Emi Lu
Дата:
Сообщение: How long - Vacumm full - 10 million to 90,000
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: How long - Vacumm full - 10 million to 90,000