Overview
Discover how to effectively scale Postgres for time series data using Citus in this conference talk from Citus Con: An Event for Postgres 2022. Learn about managing high-volume time series data, leveraging PostgreSQL's declarative partitioning feature, and distributing partitions across a cluster with Citus. Explore topics such as Postgres built-in partitioning, easy partition management, Citus Columnar, automated partition management with pg_cron, and sharding techniques. Gain insights from software engineer Burak Velioglu as he demonstrates how to transform PostgreSQL into a distributed time series database capable of handling enormous amounts of data. Watch the included demo to see these concepts in action and enhance your understanding of scaling Postgres for time series workloads.
Syllabus
Introduction.
Timeseries data and workload.
Postgres built-in partitioning.
Easy partition management with Citus.
Citus Columnar.
Automated partition management with pg_cron.
Sharding & partitioning.
Demo.
Taught by
Microsoft Developer