We are using Alfresco Community with PostGreSQL database.
Community - 5.0.0 (d r99759-b2)
psql (PostgreSQL) 9.4.5
Our database is too big - 500 GB. We do Full Vacuum every 3 months and reduce it around with 100 GB.
TrashCan is not working(Alfresco Share -> Administrator -> MyProfile -> Trashcan - Error loading items) and we cannot delete files in trash.
In Solr Index for "alfresco core" you can see how many Docs we have:
lastModified:less than a minute ago.
lastModified:2 minutes ago.
We are using auditing and workflows and uploading pictures in alfresco.
We do "partitioning" of alf_node_properties table because it has too many rows and it is the biggest table in database.
Every parted table alf_node_properties_x has 1 000 000 rows.
Summary of rows:
alfresco=> select count(*) from alf_node_properties;
Please give me a hint what we should do to reduce this big table?
There are so many rows and everything works with this table, so we see many locks in database.