rajan <vgmonnet(at)gmail(dot)com> 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