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 system

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 ha