Re: Reltuples/n_live_tup values wrong

Sebastian Kornehl <webmaster@sourcebase.org> writes:
> You might be right, I found some pg_prepared_xacts from 2013-05-23. This
> was a test with a XA using application, but the application is already
> offline. There is also no pid available for the given transaction id's.

> Do you have any idea how to close these xa transactions without
> restarting the whole db?

Just use ROLLBACK PREPARED with the ID you see in pg_prepared_xacts.

            regards, tom lane