Inside TimescaleDB | Two-step aggregation demo

📉 Learn about PostgreSQL aggregation and how PostgreSQL’s implementation inspired us as we built TimescaleDB hyperfunctions and its integrations with advanced TimescaleDB features.

In this demo and discussion session, TimescaleDB engineer, David Kohn (@HarlemCavalier), explains the concept of PostgreSQL's two-step aggregation, how it inspired TimescaleDB's hyperfunctions, and what this means for your projects. He also answers some questions from fellow TimescaleDB engineers, digging into possible use cases for hyperfunctions some potential improvements for future versions of the functions.

🛠 𝗥𝗲𝗹𝗲𝘃𝗮𝗻𝘁 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀
📌 Two-step aggregation explanation blog post ⇒ https://blog.timescale.com/blog/how-p...
📌 Learn more about hyperfunctions ⇒ https://blog.timescale.com/blog/intro...
📌 Ask your questions about our hyperfunctions in the discussion ⇒ https://github.com/timescale/timescal...
📌 See the hyperfunctions docs to get started ⇒ https://docs.timescale.com/api/latest...

🐯 𝗔𝗯𝗼𝘂𝘁 𝗧𝗶𝗺𝗲𝘀𝗰𝗮𝗹𝗲
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://tsdb.co/homepage
🔍 Slack ⇒ https://slack.timescale.com
🔍 GitHub ⇒ https://github.com/timescale
🔍 Twitter ⇒   / timescaledb  
🔍 Twitch ⇒   / timescaledb  
🔍 LinkedIn ⇒   / timescaledb  
🔍 Timescale Blog ⇒ https://tsdb.co/blog
🔍 Timescale Documentation ⇒ https://tsdb.co/docs

📚 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
⏱ 0:00 ⇒ Introduction
⏱ 3:31 ⇒ Part 1: How PostgreSQL aggregation works
⏱ 14:50 ⇒ Questions about PostgreSQL aggregation
⏱ 18:02 ⇒ Part 2: How PostgreSQL aggregation relates to two-step aggregates
⏱ 19:36 ⇒ Part 3: Why hyperfunctions use the two-step design pattern
⏱ 35:56 ⇒ Part 4: How the two-step design impacts time-weighted average code
⏱ 40:22 ⇒ Questions