Re: [firebird-support] Outdated indices

2014-01-09 Thread Dmitry Kuzmenko
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 ...

RE: [firebird-support] Outdated indices

2014-01-09 Thread Evelyne Girard
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