I’ve a cluster with the following 6 databases:
The nodes take more than 42G of disk:
The top 5 disk usage folders are:
So far I did:
- reducing the
- log_file_size_partitions from 256mb to 64mb
However, the old log files remained at 256mb.
Most of these empty databases have more than 30 log files that looks like:
- and so on…
Could you please tell us how to clean/manage those log files automatically to avoid running out of disk space?
Looks like it’s a recurring pain point and I couldn’t find more resources about it…
Thanks for your help!