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

# sk178889 - The PostgreSQL database fully utilizes disk space on the Multi-Domain Server when Smart Provisioning is enabled.

| Property | Value |
|----------|-------|
| Solution ID | sk178889 |
| Date Created | 2022-04-25 |
| Last Modified | 2022-09-04 |
| Technical Level | General |
| Products | Security Management Server, Multi-Domain Security Management Server |
| Versions | R81.10 (EOS), R81.10 (EOS) |
| OS | Gaia |
| Platform | Open Server |

## Symptoms

- * The size of */opt/CPshrd-R81.10/database/postgresql/data/base/* is bigger than 70 GB, and is inflating rapidly.
* The Postgres consumes 100% of the disk space constantly, and performance is impacted.
* The *CpmiRoboControl* table in the PostgreSQL database has more than 100,000 records.

## Cause

The LSM profiles, by default, update the policy for the SMB gateways and send HB synchronization traffic frequently.  
In large environments with more than 2000 SMBs, it significantly impacts the management server.

## Solution

This problem was fixed. The fix is included in:

* [Jumbo Hotfix Accumulator for R81.10](https://sc1.checkpoint.com/documents/Jumbo_HFA/R81.10/Default.htm) starting from Take 75

If you choose not to upgrade, follow these steps:
1. Purge database revisions manually as much as possible.  

2. Increase LSM Heartbeat interval to 12/24 hours. See [sk166432 - *How to change LSM Heartbeat interval and fetch interval*](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk166432)  

3. Configure Automatic Revisions Purge. See [https://sc1.checkpoint.com/documents/latest/APIs/index.html#cli/set-automatic-purge\~v1.7%20](https://sc1.checkpoint.com/documents/latest/APIs/index.html#cli/set-automatic-purge~v1.7%20)  

4. If steps 1-3 did not help,

[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, collect [CPinfo](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk92739) files from the Management Server and Security Gateways / Cluster Members involved in the case.

**Hotfix installation instructions:**   
Refer to [sk168597 - How to install a Hotfix](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk168597).

---

# 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
