Postgres Database growing

[kwangmien]

Hi,

I am using Fusion PBX version 4.4.6.

it is using Postgres Database and recently, the database has grown to 24GB.

I tried to clear all the CDRs but it did not reduce the size of the Database.

After checking the postgres folder, it noticed there are a lot of 1GB files in this folder

/var/lib/pgsql/9.4/data/base/16384

examples of the file are

-rw------- 1 postgres postgres 1.0G Aug 7 01:21 17031.5
-rw------- 1 postgres postgres 1.0G Aug 7 01:28 17031.6
-rw------- 1 postgres postgres 1.0G Aug 7 01:35 17031.7
-rw------- 1 postgres postgres 1.0G Aug 7 01:41 17031.14
-rw------- 1 postgres postgres 1.0G Aug 7 01:41 17031.15
-rw------- 1 postgres postgres 1.0G Aug 7 01:42 17031.16
-rw------- 1 postgres postgres 1.0G Aug 7 01:42 17031.17
-rw------- 1 postgres postgres 1.0G Aug 7 01:42 17031.18
-rw------- 1 postgres postgres 545M Aug 7 02:43 17031.19
-rw------- 1 postgres postgres 1.0G Aug 7 02:57 17031.1
-rw------- 1 postgres postgres 1.0G Aug 7 03:04 17031.2
-rw------- 1 postgres postgres 1.0G Aug 7 03:10 17031.3
-rw------- 1 postgres postgres 1.0G Aug 7 03:11 17031.4
-rw------- 1 postgres postgres 1.0G Aug 7 03:11 17031.8
-rw------- 1 postgres postgres 1.0G Aug 7 03:18 17031.9
-rw------- 1 postgres postgres 1.0G Aug 7 03:25 17031.10
-rw------- 1 postgres postgres 1.0G Aug 7 03:32 17031.11
-rw------- 1 postgres postgres 1.0G Aug 7 03:38 17031.12
-rw------- 1 postgres postgres 1.0G Aug 7 03:43 17031.13

Can anyone advise what are these files and how to clear them ?


Thanks.

Regards,
Kwang Mien

 

[DigitalDaz]

VACUUM FULL - PostgreSQL wiki

wiki.postgresql.org