Postgres Pro
Downloads
Home   >   mailing lists

Re: Dead rows not getting removed during vacuum - Mailing list pgsql-general

From Granthana Biswas
Subject Re: Dead rows not getting removed during vacuum
Date
Msg-id CAACh-pXFm4Ymw1cXGpQ8Av39RT7zYHn5FdsKD049pRnEfWJ9Aw@mail.gmail.com
Whole thread Raw
In response to Re: Dead rows not getting removed during vacuum  (Venkata Balaji Nagothi <vbnpgc@gmail.com>)
List pgsql-general
Tree view
Hi Venkata,

No there are no other connections to the DB during vacuum.

Regards,
Granthana


On Fri, Mar 21, 2014 at 3:12 AM, Venkata Balaji Nagothi <vbnpgc@gmail.com> wrote:
On Thu, Mar 20, 2014 at 5:27 AM, Granthana Biswas <granthana@zedo.com> wrote:

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.
This means there are transactions in progress when the vacuum was running. Do you see any such situation ?

Please let us know, which version of PostgreSQL is this.

Venkata Balaji N

Sr. Database Administrator
Fujitsu Australia


pgsql-general by date:

Previous
From: Venkata Balaji Nagothi
Date:
Subject: Re: Hot standby read slaves exceed max delay on WAL segment. Replication lag.
Next
From: Granthana Biswas
Date:
Subject: Re: Dead rows not getting removed during vacuum