Uploaded image for project: 'Artifactory Binary Repository'
  1. Artifactory Binary Repository
  2. RTFACT-20842

Add Database Indexes to Support AQL Queries

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Done
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 7.35.1
    • Component/s: None
    • Labels:
      None

      Description

      Currently these queries require a full scan of the nodes table. A more efficient option would be to configure database indexes. Many AQL queries filter on repo and node_type and require full scans to satisfy. A regular multi-column btree index significantly improves those queries. Additionally, on PostgreSQL both nodes_node_name_idx and nodes_node_path_idx need an operator type added, varchar_pattern_ops, to allow the indexes to be used for left anchored LIKE queries. There's also the GAVC search styles, which require trigram indexes to avoid a sequence scan of the table.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              shayb Shay Bagants
              Reporter:
              mariy Mari Yamaguchi (Inactive)
              Votes:
              9 Vote for this issue
              Watchers:
              13 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Sync Status

                  Connection: RTFACT Sync
                  RTMID-20842 -
                  SYNCHRONIZED
                  • Last Sync Date: