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

Drop OID's on Postgres databases after update

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Unsupported version
    • Icon: Trivial Trivial
    • None
    • 2.0.19, 2.2.15
    • None
    • PostgreSQL server

      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%!

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

              Created:
              Updated:
              Resolved: