rajan <vgmonnet@xxxxxxxxx> writes: > Restarting the DB and running vacuum again did recover some space. But still > there are dead rows. > vacuum full verbose chnges_23_21; > INFO: vacuuming "public.chnges_23_21" > INFO: "chnges_23_21": found 8436850 removable, 239750 nonremovable row > versions in 89460 pages > DETAIL: 0 dead row versions cannot be removed yet. No, you're misreading it. It deleted 8436850 rows, and 239750 live rows remain. We can tell they're all live because there are 0 dead-but-not- removable rows. So you're good now. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
