Postgres Pro
Downloads
Home   >   mailing lists

Re: Re: vacuum full is not reclaiming the space and showing non-removable rows - Mailing list pgsql-admin

From Tom Lane
Subject Re: Re: vacuum full is not reclaiming the space and showing non-removable rows
Date
Msg-id 18017.1479659534@sss.pgh.pa.us
Whole thread Raw
In response to Re: vacuum full is not reclaiming the space and showing non-removable rows  (rajan <vgmonnet@gmail.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Why are a lot of ROLLBACK queries in idle state
Next
From: Achilleas Mantzios
Date:
Subject: Re: Effect of archive_mode , archive_command when set on the standby