Re: Re: vacuum full is not reclaiming the space and showing non-removable rows

rajan <vgmonnet@gmail.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