Uploaded image for project: 'Dev - Nexus Repo'
  1. Dev - Nexus Repo
  2. NEXUS-28896

improve INSERT performance into format specific browse_node tables

    XMLWordPrintable

    Details

    • Story Points:
      5
    • Sprint:
      NXRM Sentinels Sprint 19, NXRM Sentinels Sprint 20
    • Notability:
      n/a

      Description

      It was noticed in a migration from repository 2 to repository 3.34.0 postgresql, that SQL INSERT into the Postgresql browse node tables had locking contention producing gradually slowing insert operations, slowing down migration overall. Version 3.34.0 builds the browse_node tables during the migration process, not after it is finished.

      Expected

      Find a more performant way to insert into the browse_node tables

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              mallen Mick Allen
              Reporter:
              plynch Peter Lynch
              Last Updated By:
              Vijay Swaminathan Vijay Swaminathan
              Team:
              NXRM - Sentinels
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Date of First Response:

                  tigCommentSecurity.panel-title