Support Center > Search Results > SecureKnowledge Details
PostgresSQL database is very big and continues to grow Technical Level
Symptoms
  • PostgresSQL database on the Management server is large and continues to grow.
  • This command shows more than 100k rows:
    psql_client cpm postgres -c "select count(*) from dleobjectderef_data where deleted and dlesession=0"
  • Purge of old revisions does not reduce the size.
Cause
Revisions purge does not remove deleted objects on public session.


Solution
Note: To view this solution you need to Sign In .