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