Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-22889

Performance problems due to missing problem.cause_eventid index on PostgreSQL

    XMLWordPrintable

Details

    • Team D
    • Sprint 101 (Jun 2023)
    • 0.5

    Description

      Reported in:
      ZBX-22675

      There is foreign key:
      "c_problem_3" FOREIGN KEY (cause_eventid) REFERENCES events(eventid)

      However no index on PostgreSQL, note that it is automatically created on MySQL.
      This causes performance problems when feature if used

      Attachments

        Issue Links

          Activity

            People

              mprihodko Mihails Prihodko
              vso Vladislavs Sokurenko
              Votes:
              8 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: