postgres - PRO-IT Rocks!

timescaledb

The Day I Discovered My TimescaleDB Was Just PostgreSQL in Disguise

For years I thought my Zabbix was using TimescaleDB. A failed upgrade revealed the truth: 391 million records in plain PostgreSQL with no optimization. My queries were 7,500x slower than they should have been. Sometimes the best discoveries come from fixing what's broken.

netbsd

Upgrade TimescaleDB extension

TimescaleDB is extension for PostgreSQL database that greatly improve performance of database by automatically partitioning data into time-based chunks to support faster performance at scale. I use it with my Zabbix server when partitioning is a must when you have large amount of statistics. However update of TimescaleDB is a