8.2rc1: vacuum full fills up disk space
От | Thomas H. |
---|---|
Тема | 8.2rc1: vacuum full fills up disk space |
Дата | |
Msg-id | 0d1b01c711e5$c6fef890$0201a8c0@iwing обсуждение исходный текст |
Ответы |
Re: 8.2rc1: vacuum full fills up disk space
|
Список | pgsql-bugs |
this somehow sounds buggy: there's this table forum.posts which had 224mb table size, 145mb toast tabl= e size and 176mb indexes size (aproximately 60'000 rows). as i was doing so= me updates of all the records, i've issued a VACUUM FULL <tablename>... this was merely 60min ago, and it hasn't yet finished... instead in pg_xlog= there are now 380+ files, totalling in over 6gb. available disk space is a= lmost used up... the table was freshly loaded yestertday when reloading for rc1. as the process of vacuuming is still ongoing, is there something i can do t= o... a) .. prevent total diskspace fillup. what happens if i send a cancel signa= l to the process? b) .. gather some "evidence" if needed? c) .. check if the vacuum process is still alive? d) .. give the process in question a higher priority so it would finish soo= ner? thanks, thomas
В списке pgsql-bugs по дате отправления: