Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-16743

Possible performance problem on workflow with PostgreSQL

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 5.8.0-HF31
    • Fix Version/s: QualifiedToSchedule
    • Component/s: Core VCS

      Description

      When NXQL queries like this are very slow

      SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND ecm:currentLifeCycleState NOT IN ('ended', 'cancelled') AND ecm:isProxy = 0 AND (nt:targetDocumentId = ? OR nt:targetDocumentsIds IN (?)) AND (nt:actors IN (?) OR nt:delegatedActors IN (?))";
      

      Adding a GIN index on mixintype fix the problem

      CREATE INDEX hierarchy_mixintypes_idx ON hierarchy USING GIN(mixintypes);
      

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: