Hi,
vacuum full verbose chnges_23_21;
INFO: vacuuming "public.chnges_23_21"
INFO: "chnges_23_21": found 0 removable, 8602500 nonremovable row versions
in 88699 pages
DETAIL: 8436850 dead row versions cannot be removed yet.
CPU 0.61s/3.38u sec elapsed 5.45 sec.
VACUUM
We deleted(using a delete query) a lot of rows from the above table and did
a vacuum full. But we are not able to reclaim the space(occupied by this
table) and the result is showing that there are nonremovable rows.
Can anyone help on how it can be fixed?
-----
--
Thanks,
Rajan.
--
View this message in context: http://postgresql.nabble.com/vacuum-full-is-not-reclaiming-the-space-and-showing-non-removable-rows-tp5930937.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.