From: Marcin Mańk <marcin.mank@gmail.com>
To: pgsql-performance@postgresql.org
Subject: VACUUM FULL hangs
Date: Wed, 15 Mar 2006 11:09:52 +0100
Message-ID: <024d01c64818$9b5790e0$0c67a8c0@maniek> (raw)
Hello list.
I recently tried to do a slony replica of my database, and doing it falied.
I retried, and then it succeeded (why it failed is another story).
This caused that in the replica there is a lot of dead tuples ( If i
understand correctly, a failure in creating the replica means a HUGE aborted
transaction - and Slony should TRUNCATE the table, getting rid of dead
tuples, but that is a subject for another list).
so I did vacuum full verbose analyze (does it make sense ?)
This hanged on a (quite large) table:
INFO: vacuuming "public.calls"
INFO: "calls": found 7980456 removable, 3989705 nonremovable row versions
in 296943 pages
DETAIL: 0 dead row versions cannot be removed yet.
Nonremovable row versions range from 136 to 224 bytes long.
There were 891 unused item pointers.
Total free space (including removable row versions) is 1594703944 bytes.
197958 pages are or will become empty, including 0 at the end of the table.
212719 pages containing 1588415680 free bytes are potential move
destinations.
CPU 7.25s/3.28u sec elapsed 144.95 sec.
INFO: index "calls_pkey" now contains 3989705 row versions in 8975 pages
DETAIL: 108927 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.35s/0.59u sec elapsed 39.03 sec.
INFO: index "calls_cli" now contains 3989705 row versions in 13504 pages
DETAIL: 108927 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.51s/0.60u sec elapsed 58.60 sec.
INFO: index "calls_dnis" now contains 3989705 row versions in 13600 pages
DETAIL: 108927 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.60s/0.90u sec elapsed 27.05 sec.
INFO: index "calls_u" now contains 3989705 row versions in 23820 pages
DETAIL: 108927 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.92s/0.78u sec elapsed 80.51 sec.
INFO: index "calls_z" now contains 3989705 row versions in 13607 pages
DETAIL: 108927 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.60s/0.85u sec elapsed 39.77 sec.
It was hanging in this state for more than 3 hours, and I had to kill the
vacuum process.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: marcin.mank@gmail.com
Subject: Re: VACUUM FULL hangs
In-Reply-To: <024d01c64818$9b5790e0$0c67a8c0@maniek>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox