Dead rows not getting removed during vacuum

From: Granthana Biswas <granthana(at)zedo(dot)com>
To: PostgreSQL General Discussion Forum <pgsql-general(at)postgresql(dot)org>
Subject: Dead rows not getting removed during vacuum
Date: 2014-03-20 12:27:24
Message-ID: CAACh-pURv74Hz9tYpp5SDaddSaMMqq=xkm9v-rNUZOC8DxFqtQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello All,

Has anyone ever faced the issue of dead rows not getting removed during
vacuum even if there are no open transactions/connections?

We have been facing this during every scheduled vacuum which is done after
closing all other database connections:

119278 dead row versions cannot be removed yet.

The number of dead rows varies with each table.

Regards,
Granthana

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shaun Duncan 2014-03-20 12:28:07 Re: Hot standby read slaves exceed max delay on WAL segment. Replication lag.
Previous Message Eduardo Morras 2014-03-20 08:56:14 Re: High Level Committers Wanted