I'm working with TMQ on a large repo (about 5 millions of docs) on a community 5.1.g.
A read in doc that optional indexes could be added by the patch (http://dev.alfresco.com/resource/AlfrescoOne/5.0/configuration/alfresco/dbscripts/upgrade/4.2/org.hibernate.dialect.Dialect/metadata-query-indexes.sql)
But I checked that these indexes are already added in my DB. Does it means that this patch applies to previous versions only ?
In some situations, eventual queries are incomparably more performant that TMQ.
(about 1000x faster in some situations). Does it make sense ? Or it means that my postgres has to be tuned ?