Ad Widget

Collapse

Housekeeping and timescaleDB

Collapse
This topic has been answered.
X
X
 
  • Time
  • Show
Clear All
new posts
  • zeebeedee
    Junior Member
    • Feb 2025
    • 2

    #1

    Housekeeping and timescaleDB

    Hello Everyone!
    Please kindly tell me, do I have to tick "Enable internal housekeeping" for history and trends when using timescaleDB ?
  • Answer selected by zeebeedee at 03-03-2025, 07:47.
    LukeAB93UK
    Member
    Zabbix Certified Specialist
    • Jun 2023
    • 72

    Originally posted by zeebeedee
    Hello Everyone!
    Please kindly tell me, do I have to tick "Enable internal housekeeping" for history and trends when using timescaleDB ?
    Hello, yes you are required to turn it on.

    3 Housekeeping

    Near the bottom of this page it states

    "If using TimescaleDB, in order to take full advantage of TimescaleDB automatic partitioning of history and trends tables, Override item history period and Override item trend period options must be enabled as well as Enable internal housekeeping option for history and trends. Otherwise, data kept in these tables will still be stored in partitions, however, the housekeeper will not drop outdated partitions, and warnings about incorrect configuration will be displayed. When dropping of outdated partitions is enabled, Zabbix server and frontend will no longer keep track of deleted items, and history for deleted items will be cleared when an outdated partition is deleted.​"

    If your new I would recommend giving the documentation a read and it has a search function as well so you can look stuff up

    Comment

    • cyber
      Senior Member
      Zabbix Certified SpecialistZabbix Certified Professional
      • Dec 2006
      • 4807

      #2
      yes. you do

      Comment

      • LukeAB93UK
        Member
        Zabbix Certified Specialist
        • Jun 2023
        • 72

        #3
        Originally posted by zeebeedee
        Hello Everyone!
        Please kindly tell me, do I have to tick "Enable internal housekeeping" for history and trends when using timescaleDB ?
        Hello, yes you are required to turn it on.

        3 Housekeeping

        Near the bottom of this page it states

        "If using TimescaleDB, in order to take full advantage of TimescaleDB automatic partitioning of history and trends tables, Override item history period and Override item trend period options must be enabled as well as Enable internal housekeeping option for history and trends. Otherwise, data kept in these tables will still be stored in partitions, however, the housekeeper will not drop outdated partitions, and warnings about incorrect configuration will be displayed. When dropping of outdated partitions is enabled, Zabbix server and frontend will no longer keep track of deleted items, and history for deleted items will be cleared when an outdated partition is deleted.​"

        If your new I would recommend giving the documentation a read and it has a search function as well so you can look stuff up

        Comment

        • zeebeedee
          Junior Member
          • Feb 2025
          • 2

          #4
          Thanks alot guys!
          Sorry, I didn't read the documentation carefully.
          Will do next time

          Comment

          Working...