another newbie question: PLEASE HELP!
От | Mark Parker |
---|---|
Тема | another newbie question: PLEASE HELP! |
Дата | |
Msg-id | ezZub.11704$Ek.9192@twister.austin.rr.com обсуждение исходный текст |
Ответы |
Re: another newbie question: PLEASE HELP!
|
Список | pgsql-general |
What happens if I kill a "vacuum full" in progress? Do I get the freed space of the tables processed up till then? The reason that I ask is that I've been doing a vacuum full for 2.5 hours now and I've seen this: INFO: Pages 66056: Changed 0, reaped 66049, Empty 0, New 0; Tup 1264285: Vac 2368115, Keep/VTL 0/0, UnUsed 2711343, MinLen 63, MaxLen 92; Re-using: Free/Avail. Space 411271648/411270572; EndEmpty/Avail. Pages 0/66022. CPU 5.55s/1.78u sec elapsed 20.13 sec. INFO: Index features_group_desc_i: Pages 919085; Tuples 1264285: Deleted 2242084. CPU 138.02s/23.94u sec elapsed 4681.73 sec. INFO: Index features_groupid_i: Pages 517781; Tuples 1264285: Deleted 2368115. CPU 123.47s/22.16u sec elapsed 2488.06 sec. INFO: Index features_featid_i: Pages 518163; Tuples 1264285: Deleted 2368115. CPU 130.52s/21.41u sec elapsed 2482.68 sec. INFO: Index features_pkey: Pages 18351; Tuples 1264285: Deleted 1187073. CPU 4.75s/11.34u sec elapsed 141.53 sec. But there hasn't been any space freed up on the drive. I had to kill the process because the system is going to fetch some new data via ftp and the db needs to be writable. I just don't understand what the heck is going on. -Mark
В списке pgsql-general по дате отправления: