The database server may experience symptoms of memory overcommit and performing basic database tuning cannot resolve the issue. This happens on Linux server that has PostgreSQL 9.6, where the Deep Security Manager (DSM) database is currently residing.
In addition, the PostgreSQL log shows the following:
< 2019-06-09 00:24:00.002 KST > WARNING: out of shared memory
< 2019-06-09 00:24:00.002 KST > WARNING: out of shared memory
< 2019-06-09 00:24:00.002 KST > WARNING: out of shared memory
< 2019-06-09 00:24:00.022 KST > WARNING: out of shared memory
< 2019-06-09 00:24:00.043 KST > WARNING: out of shared memory
< 2019-06-09 00:24:00.043 KST > WARNING: out of shared memory
< 2019-06-09 00:24:00.043 KST > WARNING: out of shared memory
< 2019-06-09 00:24:00.063 KST > WARNING: out of shared memory
< 2019-06-09 00:24:00.063 KST > WARNING: out of shared memory
Root Cause
The issue occurs because the Deep Security Manager failed to properly manage the partition tables in the PostgreSQL database, resulting in many AlertUpdateEvents tables in the database.
Solution
To resolve the issue, upgrade Deep Security Manager to version 11.0 Update 8 or higher.