Re: Reltuples/n_live_tup values wrong

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sebastian Kornehl <webmaster(at)sourcebase(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Reltuples/n_live_tup values wrong
Date: 2013-08-07 12:12:55
Message-ID: 6848.1375877575@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Sebastian Kornehl <webmaster(at)sourcebase(dot)org> writes:
> I'm facing a problem which seems like a bug to me. I'm running:

It seems like most of your problem is explained by this:

>> DETAIL: 609299 dead row versions cannot be removed yet.

You need to get rid of whatever old open transaction is preventing
those rows from getting vacuumed away. Perhaps you have a prepared
transaction lying around?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sebastian Kornehl 2013-08-07 12:50:13 Re: Reltuples/n_live_tup values wrong
Previous Message Sebastian Kornehl 2013-08-07 10:24:28 Reltuples/n_live_tup values wrong