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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
