Uploaded image for project: 'SonarQube'
  1. SonarQube
  2. SONAR-15052

Enable reWriteBatchedInserts in sonar-db-copy to improve Postgres performance

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Database
    • Labels:
      None
    • Edition:
      Enterprise
    • Production Notes:
      None

      Description

       a significant performance gain was due to enabling reWriteBatchedInserts :

      • reWriteBatchedInserts = booleanThis will change batch inserts from insert into foo (col1, col2, col3) values (1,2,3) into insert into foo (col1, col2, col3) values (1,2,3), (4,5,6) this provides 2-3x performance improvement

      So, combining, similar INSERT statements into one BIG INSERT (limiting the network packets etc and multiple transactions overhead on db side).

      According to what the customer stated in the ticket 2

      performance went from avg. 2000 rows per second to 15000-20000

      It can be set as a JDBC connection string param however maybe enabling this, in the DBCopy context, at code level makes sense as well.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              zipeng.wu Zipeng Wu
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: