I have stumbled upon a problem with Selects based on indices which do not seem
to be updated as they should.
There are no Active Transaction but there are more reads than the actual number
of records corresponding to my select conditions.
Here's an example :
create table Test1(id1 integer not
Hello, Evelyne!
Thursday, January 9, 2014, 8:57:13 PM, you wrote:
EG The problem is that the index seems to keep having old values
EG until there is not a single connection to the database (even if I
EG commit every transaction). This causes me real performance
EG problems on 24/7 systems ...
Thanks a lot for your answer Dimitry,
your problem is versions, because index keep all keys for all
versions. If you have active transactions, garbage collection
does not work, and obsolete keys and versions are not cleaned.
Check gstat -r to see how many versions tables have when you have
