Lesson 5, PostgreSQL Aggregation: How to Create and Use Custom Aggregates

In this lesson, get an overview of how PostgreSQL aggregation works and how to create and use custom aggregates.
🛠 𝗥𝗲𝗹𝗲𝘃𝗮𝗻𝘁 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀
📌 Foundations of PostgreSQL & TimescaleDB course playlist ⇒ • Course: Foundations of...
📌 Lesson 5 Presentation ⇒ docs.google.co...
📌 pgx: Develop PostgreSQL extensions in Rust ⇒ github.com/zom...
📌 pgx in the TimescaleDB Toolkit extension ⇒ github.com/tim...
📚 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀
⏱ 9:01 ⇒ Lesson 5 Agenda: How PostgreSQL aggregation works
⏱ 9:25 ⇒ (01) How PostgreSQL aggregation works (through pictures!)
⏱ 13:58 ⇒ Transition function: The State Transition function or sfunc
⏱ 16:29 ⇒ Function: The Final function (18:02)
⏱ 20:11 ⇒ Parallel workers and the background worker framework
⏱ 26:30 ⇒ (02) The CREATE AGGREGATE statement
⏱ 31:04 ⇒ Extensions and object creation hooks
⏱ 32:00 ⇒ (03) Examples of custom aggregates in SQL & Rust / pgx
⏱ 36:08 ⇒ pgx: Develop PostgreSQL extensions in Rust
⏱ 40:01 ⇒ (04) A design pattern for effective custom aggregates
⏱ 41:50 ⇒ Hyperfunctions API goals
⏱ 43:44 ⇒ General discussion on API design in SQL
⏱ 42:28 ⇒ Why two-step aggregation?
⏱ 47:55 ⇒ Multi-parameter aggregates
⏱ 50:53 ⇒ `rollup()` tells you that re-aggregation is allowed
⏱ 51:42 ⇒ `rolling()`
⏱ 53:27 ⇒ Continuous Aggregates
Why two-step aggregation? (Slide)
⏱ 1. ⇒ 42:28
⏱ 2. ⇒ 46:47
⏱ 3. ⇒ 49:16
⏱ 4. ⇒ 53:06
📝 𝗔𝗯𝗼𝘂𝘁 𝗙𝗼𝘂𝗻𝗱𝗮𝘁𝗶𝗼𝗻𝘀 𝗼𝗳 𝗣𝗼𝘀𝘁𝗴𝗿𝗲𝗦𝗤𝗟 & 𝗧𝗶𝗺𝗲𝘀𝗰𝗮𝗹𝗲𝗗𝗕 𝗖𝗼𝘂𝗿𝘀𝗲
This course is designed for beginners to SQL and database management systems. Throughout the course, we’ll be looking at various topics including schema design, basic schema design, compression, JOINs, and much more.
🐯 𝗔𝗯𝗼𝘂𝘁 𝗧𝗶𝗺𝗲𝘀𝗰𝗮𝗹𝗲
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 ⇒ tsdb.co/homepage
🔍 Slack ⇒ slack.timescal...
🔍 GitHub ⇒ github.com/tim...
🔍 Twitter ⇒ / timescaledb
🔍 Twitch ⇒ / timescaledb
🔍 LinkedIn ⇒ / timescaledb
🔍 Timescale Blog ⇒ tsdb.co/blog
🔍 Timescale Documentation ⇒ tsdb.co/docs

[@datafabrics5039]

lesson begins at 10:00

[@jaylonnichols5504]

I have been watching since lesson 0 and David and Miranda have done a great job. The only thing that I find hard to listen to is David's "Ah" "Um".

[@LanceVallis]

ruclips.net/video/kqOJ6UI6_3w/видео.html