vacuum process taking more than 33 hours
От | Mario Behring |
---|---|
Тема | vacuum process taking more than 33 hours |
Дата | |
Msg-id | 2529.5826.qm@web30013.mail.mud.yahoo.com обсуждение исходный текст |
Ответы |
Re: vacuum process taking more than 33 hours
|
Список | pgsql-sql |
Hi all,
I've executed a VACUUM FULL on a database 33GB in size. The process was going fine until it reached a index (I guess it's an index) and there it stopped for more than 30 hours...........the whole weekend......
I've canceled it but I desperately need to free some space at the server's disk. I was thinking about using the TRUNCATE statement at the table I know to be the largest one. I have some questions though:
Also, what else can I do to avoid this kind of problem? Would a REINDEX fix the problem and let the VACUUM command finish?
Please advise.
Thank you.
Best regards,
Mario Behring
I've executed a VACUUM FULL on a database 33GB in size. The process was going fine until it reached a index (I guess it's an index) and there it stopped for more than 30 hours...........the whole weekend......
I've canceled it but I desperately need to free some space at the server's disk. I was thinking about using the TRUNCATE statement at the table I know to be the largest one. I have some questions though:
- Will the TRUNCATE free disk space?
- Can I run this command and let the openNMS software running at the same time? The ONMS product will certainly try to execute INCLUDES and such.
- If the TRUNCATE indeed free disk space, what should I do next, reindex, vacuum ??
Also, what else can I do to avoid this kind of problem? Would a REINDEX fix the problem and let the VACUUM command finish?
Please advise.
Thank you.
Best regards,
Mario Behring
Finding fabulous fares is fun.
Let Yahoo! FareChase search your favorite travel sites to find flight and hotel bargains.
В списке pgsql-sql по дате отправления: