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 table.prefetch.lastdays days

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