[BUGS] Reltuples/n_live_tup values wrong

2013-08-07 Thread Sebastian Kornehl
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

Re: [BUGS] Reltuples/n_live_tup values wrong

2013-08-07 Thread Sebastian Kornehl
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

Re: [BUGS] Reltuples/n_live_tup values wrong

2013-08-07 Thread Sebastian Kornehl
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