Faster queries with time-series data on PostgreSQL: Continuous Aggregates in TimescaleDB
Performing analysis on time-series data often involves using aggregate functions to observe trends over time - functions like SUM(), AVG(), MIN(), MAX(), etc. These functions become slower over time as more and more data is aggregated, simply because more data exists. Regardless of how big and fast your server may be, reading tens of millions of records (or more) to find the average hourly CPU usage over a month will still take time and resources.
There is a better way – and TimescaleDB Continuous Aggregates can help!
In this video, Developer Advocate Ryan Booz talks about how TimescaleDB has been thoughtfully designed to provide built-in tools like Continuous Aggregates to solve some of the most resource-intensive aspects of your time-series applications. By materializing your aggregate queries to disk and intelligently updating only the parts that change over time, you can save resources and significantly improve the performance and responsiveness of your queries. Ryan also looks at how continuous aggregates are different from PostgreSQL Materialized Views.
🛠 𝗥𝗲𝗹𝗲𝘃𝗮𝗻𝘁 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀
📌 What is time-series data? ⇒ https://www.timescale.com/blog/time-s...
📌 Continuous Aggregates ⇒ https://docs.timescale.com/timescaled...
📌 What data is actually stored in Continuous Aggregates (video) ⇒ • Video
📌 Understanding refresh policies with Continuous Aggregates (video) ⇒ • #TimescaleTuesday - Fixing Continuous...
🐯 𝗔𝗯𝗼𝘂𝘁 𝗧𝗶𝗺𝗲𝘀𝗰𝗮𝗹𝗲
At Timescale, we are dedicated to serving developers worldwide, enabling them to build exceptional data-driven products that measure everything that matters. Analyzing this data across the time dimension ("time-series data") enables developers to understand what is happening right now, how that is changing, and why that is changing. We are backed by top-tier investors with a track record of success in the industry.
💻 𝗙𝗶𝗻𝗱 𝗨𝘀 𝗢𝗻𝗹𝗶𝗻𝗲!
🔍 Website ⇒ https://www.timescale.com/
🔍 Slack ⇒ https://slack.timescale.com/
🔍 GitHub ⇒ https://github.com/timescale/
🔍 Twitter ⇒ / timescaledb
🔍 LinkedIn ⇒ / timescaledb
🔍 Timescale Blog ⇒ https://blog.timescale.com/
🔍 Timescale Documentation ⇒ https://docs.timescale.com/
📚 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
⏱ 0:00 ⇒ Introduction
⏱ 0:30 ⇒ Agenda
⏱ 1:25 ⇒ Part 1: What are continuous aggregates?
⏱ 4:45 ⇒ Part 2: Compared to Postgres Materialized Views
⏱ 7:50 ⇒ Part 3: How can continuous aggregates help?
⏱ 11:35 ⇒ Part 4: Demo
⏱ 18:50 ⇒ Part 5: Future development
⏱ 21:50 ⇒ Outro
#database #timeseries #PostgreSQL #SQL
Watch video Faster queries with time-series data on PostgreSQL: Continuous Aggregates in TimescaleDB online without registration, duration hours minute second in high quality. This video was added by user Timescale 29 June 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 6,088 once and liked it 102 people.