Hi Stephan,
Thanks for a quick reply.
pbs=# SELECT oid,xmin,xmax,* FROM UserBalances WHERE UserID = 1002024;
oid | xmin | xmax | userid | balance | reservedbalance |
modificationdate
---------+-----------+-----------+---------+----------+-----------------+------------------
2080463 | 248152344 | 248307452 | 1002024 | 10000.00 | 154.02 | 1068947725
2080463 | 248274508 | 248307402 | 1002024 | 10000.00 | 727.57 | 1068949964
(2 rows)
Please let me know if there is anything else that I can test.
This happen a few time to me too and I solved not running anymore each night a REINDEX on the table. I posted this problem in the past ...
Do you scedule reindex on this table very often ?
Regards Gaetano Mendola
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
