Uploaded image for project: 'Red Hat Advanced Cluster Management'
  1. Red Hat Advanced Cluster Management
  2. ACM-3275

PostgreSQL triggers consume high CPU (release-2.7)

XMLWordPrintable

    • Observability Sprint 2023-00
    • Important
    • No

      Description of problem:

      Triggers are causing very high CPU consumption from postgres.

      Solution: Identified a problem in the trigger function that runs unnecessary logic when a row is updated. 

      Version-Release number of selected component (if applicable): 2.7.0

      How reproducible: Large scale environments

      Steps to Reproduce:

      1.  
      2.  
      3. ...

      Actual results:

      Expected results:

      Additional info:

        1. image-2023-02-07-19-43-39-238.png
          image-2023-02-07-19-43-39-238.png
          160 kB
        2. image-2023-02-22-16-56-16-182.png
          image-2023-02-22-16-56-16-182.png
          938 kB

            jpadilla@redhat.com Jorge Padilla
            jpadilla@redhat.com Jorge Padilla
            Xiang Yin Xiang Yin
            ACM Observability Search
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: