Re: Reltuples/n_live_tup values wrong

From: Greg Stark <stark(at)mit(dot)edu>
To: Sebastian Kornehl <webmaster(at)sourcebase(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Reltuples/n_live_tup values wrong
Date: 2013-08-07 12:58:28
Message-ID: CAM-w4HOgT5-yqpX5D=XMtYR2awYwZYsz+3VoZsEpmifT7DsrwA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, Aug 7, 2013 at 1:50 PM, Sebastian Kornehl
<webmaster(at)sourcebase(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2013-08-07 13:30:39 Re: Reltuples/n_live_tup values wrong
Previous Message Sebastian Kornehl 2013-08-07 12:50:13 Re: Reltuples/n_live_tup values wrong