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

history_text_2 doesn't need to be a unique index

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Trivial
    • Resolution: Duplicate
    • Affects Version/s: 2.0.6
    • Fix Version/s: None
    • Component/s: Server (S)
    • Environment:
      Centos 6.4 x64, PostgreSQL 9.1

      Description

      history_text table on PostgreSQL has 3 indexes:
      "history_text_pkey1" PRIMARY KEY, btree (id)
      "history_text_2" UNIQUE, btree (itemid, id)
      "history_text_1" btree (itemid, clock)

      Since the primary key is already unique, the history_text_2 index doesn't need to be unique at all.

      Also why does the history_text table out of all history tables the only one that has additional two indexes besides the (itemid, clock) index? Are they really needed.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              kustodian Strahinja Kustudic
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: