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

    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
                Assigned QA:
                Alex Dvorkin
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: