Configurable task intervals for automatic index deletion
Details
| Detail name | Value |
|---|---|
| Changelog Number | 5591 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | EXASolution 5.0.21 |
| Resolution Date | 2018-01-08 |
The logserver process (session 4) is responsible for dropping no longer needed indices. To accomplish this, the logserver checks once a day at midnight all indices for their lifetimes. This check read locks every table in the database.
Problem
There is a small chance that these logserver tasks cause user ETL sessions to be forcefully rolled back (transaction conflicts).
Solution
With this improvement, the index maintenance tasks can be turned off by setting the database parameter
-indexDeleteInterval=31536000
This setting increases the index maintenance interval from once a day to once a year.
