Re: BUG #13426: table bloat - dead rows not removed after vacuum - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: BUG #13426: table bloat - dead rows not removed after vacuum
Date
Msg-id 1867376762.603220.1433974602221.JavaMail.yahoo@mail.yahoo.com
Whole thread Raw
In response to Re: BUG #13426: table bloat - dead rows not removed after vacuum  (Jamie Koceniak <jkoceniak@mediamath.com>)
List pgsql-bugs
Jamie Koceniak <jkoceniak@mediamath.com> wrote:
> David G. Johnston [mailto:david.g.johnston@gmail.com] wrote:

>> One possibility is that you have a long-running transaction
>> holding up cleanup.

> No long running queries are in pg_stat_activity.

It doesn't take a long-running *query* to cause a problem; it only
takes a long-running *transaction*.  Look for transactions which
are "idle in transaction" with an old xact_start value.  Also check
the pg_prepared_xacts view for rows with a "prepared" value that is
more than a few seconds old.  Either will prevent the cleanup of
dead rows.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-bugs by date:

Previous
From: Jamie Koceniak
Date:
Subject: Re: BUG #13426: table bloat - dead rows not removed after vacuum
Next
From: Venkata Balaji N
Date:
Subject: Re: BUG #13425: Not able to import osm data into database