too large database

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

12charpassword

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/84359#M4727

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-index/m-p/305519/highlight/true#M23402

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.

abhinavmishra14

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/