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

Drop OID's on Postgres databases after update

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Trivial
    • Resolution: Unsupported version
    • Affects Version/s: 2.0.19, 2.2.15
    • Fix Version/s: None
    • Component/s: None
    • Environment:
      PostgreSQL server

      Description

      Zabbix 1.8 and maybe 2.x created the default tables in Zabbix with OID's explicitly enabled.

      The OID isn't used, and isn't created with modern Zabbix installations, and OID's should be dropped from the PostgreSQL instances when upgrading.

      Removing OID from a Postgres table involves locking the table for reads & Writes, and will re-write the entire table & indexes.

      This process can be. very long, especially with a lot of history or trends in the tables. For our system it was several hours, and the database shrunk with almost 60%!

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              spider D.Spindel Ljungmark
            • Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: