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.
