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

Proposal: To remove feature vacuum (PostgreSQL) of source zabbix

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Major Major
    • None
    • 1.4, 1.4.1, 1.4.2, 1.4.3, 1.4.4, 1.4.5
    • Server (S)
    • None
    • Use Zabbix with storage PostgreSQL Database.

      The feature vacuum of the zabbix in the new versions PostgreSQL is generaty overhead in the server, because the zabbix execute manually vacuum in the housekeeper table. When it monitors very itens (200 or more) is occuring two or more instance of vacuum the same table (housekeeper). I believe that execute vacuum is responsibility of DBA and execute outside software (zabbix) with jobs or task.

      Also The PostgreSQL 8.3 and major has by default feature autovacuum that execute vacuum in the better time and don't have overhead in the server. I remove feature vacuum of the Zabbix and the performance improved considerably to build zabbix without vacuum.

        1. remove_vacuum.patch
          3 kB
          Fernando Ike de Oliveira

            sasha Alexander Vladishev
            fike Fernando Ike de Oliveira
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: