...
| Code Block | ||
|---|---|---|
| ||
call clean_cache_database('DATABASE_NAME') |
Database Maintenance
Using cron to run Running VACUUM FULL on Postgres weekly to reclaim can return unused space freed up by cache maintenance back to the OS.
This readme outlines the use of cron for postgres on the Denodo DB servers.This is done automatically if using Amazon RDS.
Monitoring
...