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 ... some query wich ran in less than a second now EG> take a minute to go. 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 performance problems. -- Dmitry Kuzmenko, www.ib-aid.com