> Source: [sk166555](https://support.checkpoint.com/results/sk/sk166555)

# sk166555 - PostgresSQL database is very big and continues to grow 

| Property | Value |
|----------|-------|
| Solution ID | sk166555 |
| Date Created | 2020-05-10 |
| Last Modified | 2022-05-01 |
| Technical Level | General |
| Products | Security Management Server, Multi-Domain Security Management Server |
| Versions | R82.10, R82, R81.20, R82.10, R82.x, R82.20, R82.x, R81.20, R82, R82.20 |

## 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.

<br />

## Solution

This problem was fixed. The fix is included in:

* [Check Point R81](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk166715)
* [Jumbo Hotfix Accumulator for R80.40 starting from Take 83](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk165456&partition=Basic&product=All)
* [Jumbo Hotfix Accumulator for R80.30 starting from Take 219](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk153152&partition=Basic&product=Endpoint)
* [Jumbo Hotfix Accumulator for R80.20 starting from Take 187](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk137592&partition=Basic&product=All)

If you do not wish to upgrade, [Contact Check Point Support](https://www.checkpoint.com/support-services/contact-support/) to get a Hotfix for this issue.   
A Support Engineer will make sure the Hotfix is compatible with your environment before providing the Hotfix.   
For faster resolution and verification please collect [CPinfo](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk92739) file from the Security Management and involved in the case.

---

# Agent Instructions

This content is from the Check Point Support Center (https://support.checkpoint.com), the official knowledge base for Check Point cybersecurity products.

## Navigating This Knowledge Base

- **Complete index**: [llms.txt](https://support.checkpoint.com/llms.txt)
- **All SK articles**: [SecureKnowledge Sitemap](https://support.checkpoint.com/sitemaps/secureknowledge-sitemap-index.xml)
- **SK article URL pattern**: `https://support.checkpoint.com/results/sk/{skId}`
- **Markdown responses**: AI bot User-Agents automatically receive `text/markdown` content