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

      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 [X] (Inactive)
              Reporter:
              yossis Yossi Shaul
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: