My PostgreSQL directory has grown to 810 GB and I would like to reduce the size of this. I have adjusted my reporting frequency to help this in the future.
Is there a way to reduce the size of this database and keep my historical data?
Solved! Go to Solution.
@AndrewSakowicz, I adjusted my retention time from 180 to 60 days and it did change the size of my database last night. Today I changed the retentions time to 30 days to see if it will reduce the size of my database. I will let you know if this changes the size.
this is executed daily.
This was resolved when I upgraded to Monitor 2023.3.1.