From: rajan <vgmonnet@gmail.com>
To: pgsql-admin@postgresql.org
Subject: vacuum full is not reclaiming the space and showing non-removable rows
Date: Fri, 18 Nov 2016 05:00:49 -0700 (MST)
Message-ID: <1479470449084-5930937.post@n3.nabble.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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-...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: vgmonnet@gmail.com
Subject: Re: vacuum full is not reclaiming the space and showing non-removable rows
In-Reply-To: <1479470449084-5930937.post@n3.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox