Re: Reltuples/n_live_tup values wrong - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Reltuples/n_live_tup values wrong
Date
Msg-id 6848.1375877575@sss.pgh.pa.us
Whole thread Raw
In response to Reltuples/n_live_tup values wrong  (Sebastian Kornehl <webmaster@sourcebase.org>)
Responses Re: Reltuples/n_live_tup values wrong
List pgsql-bugs
Sebastian Kornehl <webmaster@sourcebase.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

pgsql-bugs by date:

Previous
From: Sebastian Kornehl
Date:
Subject: Reltuples/n_live_tup values wrong
Next
From: Sebastian Kornehl
Date:
Subject: Re: Reltuples/n_live_tup values wrong