PostgresSQL is one of the supported database engines that Zabbix uses to store all configuration data and history. The popularity of Postgres makes it a very sought-after Database engine for Zabbix. TimescaleDB is a great extension to Postgres that empowers Zabbix with native partitioning functionality and data compression, which saves a lot of disk space for our users.
This article will recall the most important theses about the plugin for PostgreSQL monitoring for Zabbix Agent 2. Here you’ll find the explanation of how the plugin works under the hood illustrated with a simple example. You will also get familiar with a new mechanism of custom queries that let you collect metrics from separate SQL files on PC.
Why do we recommend upgrading to the latest version? Zabbix 5.0 goes with improved stability, performance, and security, as well as provides technical support for the next five years. What’s important, Zabbix 5.0 supports TimescaleDB, which is designed to enhance performance and compresses the data.
Open-Future is a company based in Nossegem (Belgium), focused exclusively on the open-source market. Read the case showing how the company upgraded to Zabbix 4.4 and migrated from PostgreSQL table partitioning to PostgreSQL with TimescaleDB to ensure Zabbix support.
Patrik Uytterhoeven is an opensource minded consultant working for Open-Future – one of the oldest Zabbix partners. Patrik is a certified Zabbix trainer and also the author of the Zabbix Cookbook and co-author of the Zabbix 4 network monitoring book. At Zabbix Conference Benelux 2020 he will speak about upgrading Zabbix and migrating from PostgreSQL table partitioning to PostgreSQL with TimescaleDB.
Every monitoring system has to deal with three kinds of performance-related challenges.
Firstly, a good monitoring system must receive, process and record incoming data very quickly. Every microsecond counts here. This may not seem obvious from the start but when your system becomes large enough all the tiny fractions of seconds add up to become seconds if not minutes.
