AnsweredAssumed Answered

HUGE database size

Question asked by willisadams on Nov 14, 2015
Latest reply on Aug 3, 2016 by willisadams
We started with Alfresco Community Edition 5.0.d.  We later upgraded to the 201508 Early Access release of 5.1.  Later still, we upgraded to the 201509 and now, today, the 201510 EA.

The updates all went smoothly. I followed the directions found here:

During the latest update (from 201509 to 201510), the pg_dump step took a lot longer than it usually does.  When it finished, the dump file size was almost 16GB! Our entire alf_data directory only has around 65,000 files totaling 12.6GB.

Still, I loaded dump file into the new installation and everything seems to be working okay.  Using the pgAdmin tool I can connect the running alfresco database and see that it has a total size of 9275MB.  All of the tables in the database are pretty small (a few dozen KB or MB) with the exception of two tables: alf_prop_serializable_value is 8297MB and alf_prop_value is 872MB.

Is this normal?  If not, any suggestions on getting this problem under control?

Thanks in advance for your assistance.

EDIT: For reference, we are uploading most of our files to Alfresco using the built-in SMB server, but we're also using the Share web interface and the built-in IMAP server (clients use Thunderbird to connect). We aren't using any third-party add-ons. Our OS is CentOS 7 running in a VM on a Debian 8 KVM host. Let me know if you need any other info or want me to post logs.