Hi,
I'm facing a problem which seems like a bug to me. I'm running:
centos 5.9
postgresql92.x86_64 (9.2.4-1PGDG.rhel5)
I have a table whith many inserts/deletes
select * from pg_stat_user_tables where schemaname = 'lobby' and
relname = 'lobby_player' order by n_live_tup desc;
relid | schemana
se xa transactions without
restarting the whole db?
Thank you.
-Sebastian
On 08/07/2013 02:12 PM, Tom Lane wrote:
Sebastian Kornehl 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 de
Thank you, that did it!
On 08/07/2013 03:30 PM, Tom Lane wrote:
Sebastian Kornehl 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