On 10/29/2013 12:41 PM, Gregory Haase wrote:
db_name=# VACUUM FULL VERBOSE table_schema.table_name;
INFO:  vacuuming "table_schema.table_name"
INFO: "table_name": found 2 removable, 29663 nonremovable row versions in 1754 pages
DETAIL:  0 dead row versions cannot be removed yet.
CPU 0.07s/0.10u sec elapsed 0.30 sec.

is there an old transaction pending? that 'masks' vacuum from touching any tuples newer than the start of that transaction.



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast

Reply via email to