Alfresco database (postgress, especially alf_node and alf_node_properties tables and indexes in it) too large. Is it possible to set up which properties I want to store in database and which I dont? I'm using cmis queries to find documents, but almost all of them is done with UUID, and only one by cmis:name property, so, I suppose, I can drop almost all data from alf_node_properties table.
Also, I found this topic - https://hub.alfresco.com/t5/alfresco-content-services-forum/compacting-postgresql-database-size/m-p/...
where villdre mention cleanup job with cron expression. It is not enabled by default?
In this topic - https://hub.alfresco.com/t5/alfresco-content-services-forum/questions-about-search-and-database-inde...
sufo suggest to drop indexes. Is it possbile to find out, how it can affect performance without dropping them? Is there some kind of document which describe when it used? Of course I can drop them and check what work slow (or not work at all), but it did not looks right.
ps I found if I call query "reindex table alf_node_properties" it change size of indexes in two times. Not sure it related to my current database-alfresco stack, not sure it will not grow again, but it is as it is - 50% size reduction.
You can only control your custom model properties.
Its a good idea not to play around alfresco's core tables that are setup by default. They are created and optimized keeping the repository in consideration and they are purposefully maintained.
Also the indexes depend on the size of your content,metadata,permissions etc.
You can also go through this documentation: https://docs.alfresco.com/content-services/6.0/develop/software-architecture/
Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.
Related links:
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.