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

turn auditlog table into hypertable

    XMLWordPrintable

Details

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

    Description

      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

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: