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

Task table missing index on foreign key constraint

XMLWordPrintable

    • Sprint 102 (Jul 2023), Sprint 103 (Aug 2023)
    • 0.5

      Performance can be slow when deleting host when there are many tasks on PostgreSQL due to missing index, note that MySQL create this index automatically

      Indexes:
    "task_pkey" PRIMARY KEY, btree (taskid)
    "task_1" btree (status, proxy_hostid)
Foreign-key constraints:
    "c_task_1" FOREIGN KEY (proxy_hostid) REFERENCES hosts(hostid) ON DELETE CASCADE

        1. ZBX-23105-6.0-postgresql.sql
          1 kB
        2. ZBX-23105-6.4-postgresql.sql
          1 kB
        3. ZBX-23105-6.5-postgresql.sql
          1 kB

            dimir dimir
            vso Vladislavs Sokurenko
            Team A
            Votes:
            2 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: