Vacuum full progress

From: Carlos Henrique Reimer <carlos(dot)reimer(at)opendb(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Vacuum full progress
Date: 2010-09-05 10:13:36
Message-ID: AANLkTinfzTR-+HCsJ=2n=GH3Ng+B2g0KiSzNPwNBEqVK@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I need to shrick a table with 102 GB and approximately 380.000.000 rows.

There is a vacuum full running for 13 hours and the only messages a get are:

INFO: vacuuming "public.posicoes_controles"
INFO: "posicoes_controles": found 43960 removable, 394481459 nonremovable
row versions in 13308976 pages
DETAIL: 0 dead row versions cannot be removed yet.
Nonremovable row versions range from 193 to 217 bytes long.
There were 136382074 unused item pointers.
Total free space (including removable row versions) is 27663157952 bytes.
2884123 pages are or will become empty, including 0 at the end of the table.
4167252 pages containing 27597464344 free bytes are potential move
destinations.
CPU 100.81s/101.45u sec elapsed 3347.95 sec.
The relfilenode points to the 38611 object and I see that there are 102
38611.n files in the data directory representing this table. From this
102 38611.n files only 53 were updated since the vacuum full process
started.

I need to answer these questions:

a) Is there a way to have a general idea if the process is at the end? Is
there a way to identify the progess of the work?
b) How much space will be shrank at the time vacuum full finishes?

Thank you!

--
Reimer
47-3347-1724 47-9183-0547 msn: carlos(dot)reimer(at)opendb(dot)com(dot)br

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2010-09-05 10:59:08 Re: Vacuum full progress
Previous Message Thom Brown 2010-09-05 09:26:26 Re: stack depth limit exceeded