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.
When load testing my (LTS2015 HF27 + PosgreSQL 9.6 + ElasticSearch 1.x) platform with Tsung , i get a (very) slow query as shown below .
Even if create the index as suggested by PoWa : CREATE INDEX hierarchy_mixintypes_idx /> ON public.hierarchy /> USING gin (mixintypes COLLATE pg_catalog."default");
Regards, Henri
index suggestions by PoWa
Your query contains NX_ACCESS_ALLOWED which means you disabled the ACL optimizations. It's unavoidable that with a largish amount of data any query will become slow. See https://doc.nuxeo.com/nxdoc/read-acls/
NX_ACCESS_ALLOWED
Make sur you define nuxeo.vcs.optimizations.acl.enabled=true and follow the guide in the page above (REBUILDING READ ACLS) to make sure the indexes needed are recomputed after you do the switch.
nuxeo.vcs.optimizations.acl.enabled=true
We defined nuxeo.vcs.optimizations.acl.enabled=false in order to minimize the ACL write time, as recommended in https
Could you execute your query in pgAdmin with EXPLAIN ANALYZE commands and check result on page https
