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

From Greg Stark
Subject Re: Reltuples/n_live_tup values wrong
Date
Msg-id CAM-w4HOgT5-yqpX5D=XMtYR2awYwZYsz+3VoZsEpmifT7DsrwA@mail.gmail.com
Whole thread Raw
In response to Re: Reltuples/n_live_tup values wrong  (Sebastian Kornehl <webmaster@sourcebase.org>)
List pgsql-bugs
On Wed, Aug 7, 2013 at 1:50 PM, Sebastian Kornehl
<webmaster@sourcebase.org>wrote:

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


Restarting the database wouldn't accomplish anything. Prepared transactions
are persistent across reboots.

http://www.postgresql.org/docs/9.3/static/sql-rollback-prepared.html


--
greg

pgsql-bugs by date:

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