#TimescaleTuesday: Common questions with Continuous Aggregates

#TimescaleTuesday is a weekly stream that explores TimescaleDB features and questions. In this episode, @ryanbooz and @attilatothdev discuss Continuous Aggregates, addressing questions about refresh policies, common misunderstandings about bucket sizes, and how real-time aggregates work.

🛠 𝗥𝗲𝗹𝗲𝘃𝗮𝗻𝘁 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀

🐯 𝗔𝗯𝗼𝘂𝘁 𝗧𝗶𝗺𝗲𝘀𝗰𝗮𝗹𝗲
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.

💻 𝗙𝗶𝗻𝗱 𝗨𝘀 𝗢𝗻𝗹𝗶𝗻𝗲!

📚 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
⏱ 0:00 ⇒ Introduction
⏱ 11:15 ⇒ Part 1: What are continuous aggregates?
⏱ 21:20 ⇒ Part 2: How do continuous aggregates help?
⏱ 34:25 ⇒ Part 3: Common questions about concrete aggregates
⏱ 34:10 ⇒ Part 4: Demo
⏱ 1:11:10 ⇒ Next steps

[tomyang]

Is there any best practice in adding new columns to a table? Right now it seems quite tedious to have to drop all the continuous aggregates before adding a new column to the hypertable