Content Comparison

...

Cache Maintenance Tasks

Anchor
cache-maintenance cache-maintenance

While Denodo has a maintenance routine that will clean the cache after a set period of time, it’s better to use the Scheduler to accomplish this, so that the cleaning can occur off hours to prevent impacts to performance.

Cache maintenance jobs have the clean_ prefix and use the following VQL to perform the maintance:

...

...

A job called clean_all_database_caches is deployed in Denodo Scheduler in each environment. It runs at 4 AM on Sunday each week.

You can see the results of each run with the following query:

select * from admin.p_clean_all_database_caches;

Database Maintenance

Running VACUUM FULL on Postgres can return unused space freed up by cache maintenance back to the OS.

...