another newbie question: PLEASE HELP! - Mailing list pgsql-general

From Mark Parker
Subject another newbie question: PLEASE HELP!
Date
Msg-id ezZub.11704$Ek.9192@twister.austin.rr.com
Whole thread Raw
Responses Re: another newbie question: PLEASE HELP!
List 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 by date:

Previous
From: Stef
Date:
Subject: Re: Point-in-time data recovery - v.7.4
Next
From: Shridhar Daithankar
Date:
Subject: Re: "Transaction over connections"