Re: BUG #13426: table bloat - dead rows not removed after vacuum

On Wed, Jun 10, 2015 at 10:02 AM, <jkoceniak@mediamath.com> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      13426
> Logged by:          Jamie
> Email address:      jkoceniak@mediamath.com
> PostgreSQL version: 9.1.14
> Operating system:    x86_64-unknown-linux-gnu debian
> Description:
>
> I have a table that is growing out of control.
>
> After doing a vacuum, the dead rows still remain. Why can't they be
> removed?
>
> DETAIL:  214063622 dead row versions cannot be removed yet.
>

=E2=80=8BOne possibility is that =E2=80=8B
you have a long-running transaction holding up cleanup.

Viewing "pg_stat_activity" will be informative.

=E2=80=8BDavid J.