07:44How to scale Postgres for time series data with Citus | Citus Con: An Event for Postgres 2022
From the creator
Video of a conference talk by Burak Velioglu at Citus Con: An Event for Postgres. Abstract: Managing time series data at scale can be a challenge. PostgreSQL offers many powerful data processing features such as indexes, COPY, and SQL—but the high data volumes and ever-growing nature of time series data can cause your database to slow down over time. Fortunately, Postgres has a built-in solution to this problem: Partitioning tables by time range. Partitioning with the Postgres declarative partitioning feature can help you speed up query and ingest times for your time series workloads. Though, you’ll still be limited by the memory, CPU, and storage resources of your Postgres server. The good news is you can scale out your partitioned Postgres tables to handle enormous amounts of data by distributing the partitions across a cluster using Citus. This talk will guide you to using Postgres with Citus (and pg_cron) for time series data—effectively transforming PostgreSQL into a distributed time series database with Citus. Burak Velioglu is a software engineer at Microsoft working in the Citus open source engineering team. Interested in distributed systems, machine learning, analytics, and anything related, Burak is a former researcher with an MSc in brain decoding. ► Video bookmarks: ⏩ 00:00 Introduction ⏩ 01:31 Timeseries data and workload ⏩ 03:39 Postgres built-in partitioning ⏩ 07:25 Easy partition management with Citus ⏩ 09:36 Citus Columnar ⏩ 14:44 Automated partitio
Published 2022-04-12 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.
Keep exploring Learn to Code
07:44
11:14
09:48
10:30
15:34
8:56:30C Language Full Course Part 1 | Beginner to Advanced with 100+ Questions and Notes
College Wallah
42:31Part 1 | Introduction To Programming | C Programming Malayalam Tutorial
Brototype Malayalam