• RoundSparrowM
    link
    fedilink
    1
    edit-2
    1 year ago

    This is on an empty freshly deleted data directory for PostgreSQL, and the average is skewed down in favor of the first INSERT performance which grows higher and higher the larger the table gets

    The UPDATE statements in this list:

    This is with the optimized post_aggregates logic to only do one update per INSERT instead of 3. If you add up the average times for the UPDATE statements in the screen shot, you see about 10ms of overhead for every INSERT of a comment.

    • RoundSparrow @ BTOPM
      link
      fedilink
      1
      edit-2
      1 year ago

      313617

                        status_message                       
      

      copy comment temp table into main post table, kicking off (1 row)

       avg     |     min     |     q1      |   median    |     q3      |     p95     |     max     | repeats  
      

      -------------±------------±------------±------------±------------±------------±------------±--------
      3336308.709

      3,336 seconds… 55.6 minutes