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

    • Sprint 101 (Jun 2023)
    • 0.5

      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

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

              Created:
              Updated:
              Resolved: