Indexes standard usage & Free up Indexes space
Indexima is based on the fact that Indexes are stored in RAM so that the engine can answer SQL queries the quickest possible.
In order not to overuse RAM in Indexes storage,
At Indexima restart, the Indexima engine will load indexes accessed during the last
When Indexima needs to free up some memory, Indexima will automatically unload some indexes.
Admin users may want to free up memory.
They can unload all indexes of a particular table using the command UNLOAD TABLE
They can unload all indexes of all tables of a particular schema using the command UNLOAD SCHEMA
Manual unloading of tables, whatever the command, will override the
table.prefetch.lastdays rule at cluster restart: indexes that may have been used in the past
table.prefetch.lastdays days would not be loaded