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

Performance improvement: Create a more efficient index on prop_value in PostgreSQL and limit the field length in the code

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 5.7.0, 6.1.0
    • Fix Version/s: 6.5.0
    • Labels:
      None

      Description

      In some scenarios (i.e. Artifactory instances that have not migrated to SHA2 support), Artifactory might dynamically generate SQL queries with join between the 'nodes' and 'node_props' tables. Due to inefficient index in the 'node_props' table on PostgreSQL DB, the response time of these queries might be slow. This mainly affects Docker repositories. 

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              shayb Shay Bagants
              Reporter:
              yossis Yossi Shaul
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: