cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

PostgreSql PW size continious increase

alfred_raouf3
Inactive

The PostgreSQL performance warehouse at one customer keeps growing at daily rate of 3 - 4 GB at one customer. It is now about 265 GB and it just keeps on growing. I have checked that the maintenance task executes successfully. The data retention is the default and the size of the deployment is about 250 agents, so not huge. The deployment has been running for a few months now, so it should more or less stop growing rapidly as it is doing now.

Is this a normal behavior? Anything I should check? Any suggestions?

1 REPLY 1

BabarQayyum
Leader

Hello Alfred,

We can roughly calculate with a total space of 2 GB needed per 1,000 Measures, so according to this calculation we can perform a test run with your System Profile and get the number of measures from the chart. This gives us a real number and you will not need to estimate.

Check the following link for the database server / performance warehouse Best practices:

https://community.dynatrace.com/community/display/...

Regards,

Babar