Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-8520

turn auditlog table into hypertable

XMLWordPrintable

    • Team C
    • Sprint 102 (Jul 2023), Sprint 103 (Aug 2023)
    • 2

      1) this can take considerable amount of space.

               table_name         | pg_size_pretty | pg_relation_size
      ----------------------------+----------------+------------------
       auditlog                   | 635 GB         |     681780338688
       item_discovery             | 26 GB          |      28250169344
      

      2) it has clock column
      3) its historic records do not get modified
      4) this should be easy to do, for new installations our timescalesdb script could be modified like:

      PERFORM create_hypertable('auditlog', 'clock', chunk_time_interval => 86400, migrate_data => true)
      

      and for the existing installations, separate upgrade patch could be provided in a file that users could run manually

            askolmeisters Armands Arseniuss Skolmeisters
            arimdjonoks Artjoms Rimdjonoks
            Team C
            Votes:
            3 Vote for this issue
            Watchers:
            12 Start watching this issue

              Created:
              Updated:
              Resolved: