| From: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
|---|---|
| To: | Jamie Koceniak <jkoceniak(at)mediamath(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #13426: table bloat - dead rows not removed after vacuum |
| Date: | 2015-06-10 22:16:42 |
| Message-ID: | 1867376762.603220.1433974602221.JavaMail.yahoo@mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Jamie Koceniak <jkoceniak(at)mediamath(dot)com> wrote:
> David G. Johnston [mailto:david(dot)g(dot)johnston(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Venkata Balaji N | 2015-06-10 23:27:57 | Re: BUG #13425: Not able to import osm data into database |
| Previous Message | Jamie Koceniak | 2015-06-10 21:39:45 | Re: BUG #13426: table bloat - dead rows not removed after vacuum |