another newbie question: PLEASE HELP!

From: "Mark Parker" <markus_ext(at)senator(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: another newbie question: PLEASE HELP!
Date: 2003-11-20 06:55:06
Message-ID: ezZub.11704$Ek.9192@twister.austin.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex 2003-11-20 07:22:14 SELECT Question
Previous Message Shridhar Daithankar 2003-11-20 06:22:37 Re: Picture with Postgres and Delphi