28.01.2026 –, 107
Jazyk: Čeština
The session provides a walkthrough of key TimescaleDB features used for IoT data collection and visualization. It explores the functionality and benefits of continuous aggregates (CAGGs), data compression, and data retention - highlighting how these features relate to each other and how to maintain them effectively.
The talk also compares approaches tailored to different data characteristics (dense vs. sparse datasets) and discusses how these choices impact downstream tools such as Grafana dashboards.
I’ve been working with databases since around 2000 and have focused entirely on PostgreSQL since 2010. Over the years, I’ve gained hands-on experience building performant, mission-critical software - experience that I’ve been able to pass on while leading database development teams.
I enjoy sharing practical insights on software architecture and programming, and helping others connect more closely with the PostgreSQL community.