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: