TimescaleDB Course – PostgreSQL for Time-Series Data
Learn how to supercharge PostgreSQL for time-series data and heavy analytics workloads using the TimescaleDB extension. In this comprehensive course, you will master hypertables, continuous aggregates, and columnar storage by building real-world projects like an AI agent flight recorder and an EV fleet telemetry dashboard.🏗️ Tiger Data provided a grant to make this course possible.
Get $1,000 credit on Tiger Cloud to follow along: https://tsdb.co/fcc-learn-tsdb
Chapters
- 0:00:00 Introduction & Database Comparison
- 0:01:06 Course Overview
- 0:01:28 Sponsor (Tiger Data & Tigercloud)
- 0:02:27 What is Time Series Data?
- 0:04:19 Projects Overview
- 0:05:24 It's Just PostgreSQL
- 0:06:54 Example Data Setup
- 0:10:20 The 20% of SQL You Need
- 0:19:34 Understanding EXPLAIN & ANALYZE
- 0:24:59 Pages & Row Storage
- 0:26:09 MVCC, Dead Rows & Vacuuming
- 0:29:27 Native Postgres Partitioning vs. TimescaleDB
- 0:32:42 What is a Hypertable?
- 0:33:14 Materialized Views & Summary Tables
- 0:37:05 The Dashboard Problem (Web Analytics Scenario)
- 0:44:14 Creating a Hypertable
- 0:48:43 The Golden Rule: Always Filter by Time
- 0:49:31 How Big Should a Chunk Be?
- 0:54:21 Testing Hypertable Performance
- 0:59:14 Indexing & Chunk Skipping
- 1:03:50 Global Unique Indexes & UUID v7
- 1:13:45 Data Locality & Reordering
- 1:15:42 The Column Store
- 1:18:36 Columnar Compression Techniques
- 1:22:58 Segment By & Order By
- 1:26:15 Converting Chunks to Column Store
- 1:29:03 Compressed Indexes & Bloom Filters
- 1:32:27 Continuous Aggregates
- 1:38:08 Real-Time Aggregates
- 1:40:30 Aggregate Ladders
- 1:44:50 Hyperfunctions & Gap Filling
- 1:50:16 State Aggregates
- 1:52:28 Approximate Aggregates & Percentiles
- 1:55:58 HyperLogLog (Approximate Count Distinct)
- 1:57:26 Other Toolkit Features
- 1:59:30 Data Retention Policies
- 2:04:47 Tiered Storage
- 2:08:42 Docker Setup & Environment Configuration
- 2:16:35 Project 1: AI Agent Flight Recorder
- 2:22:04 Project 1: Schema Design
- 2:28:22 Project 1: Ingestion Script & Batch Copy
- 2:35:45 Project 1: Optimizing the Database
- 2:50:56 Project 1: Querying Raw Data
- 3:00:13 Project 1: API & Dashboard Integration
- 3:15:54 Project 2: EV Fleet Telemetry & TigerCloud
- 3:22:20 Project 2: Schema Design
- 3:25:52 Project 2: The Analytics Join Myth
- 3:27:26 Project 2: Segment By Benchmarking
- 3:42:32 Project 2: Finding Anomalies
- 4:02:13 Project 2: Semantic Search (pgvector)
- 4:08:47 TigerCloud Console Overview
- 4:14:26 12-Step Production Checklist Receive SMS online on sms24.me
TubeReader video aggregator is a website that collects and organizes online videos from the YouTube source. Video aggregation is done for different purposes, and TubeReader take different approaches to achieve their purpose.
Our try to collect videos of high quality or interest for visitors to view; the collection may be made by editors or may be based on community votes.
Another method is to base the collection on those videos most viewed, either at the aggregator site or at various popular video hosting sites.
TubeReader site exists to allow users to collect their own sets of videos, for personal use as well as for browsing and viewing by others; TubeReader can develop online communities around video sharing.
Our site allow users to create a personalized video playlist, for personal use as well as for browsing and viewing by others.
@YouTubeReaderBot allows you to subscribe to Youtube channels.
By using @YouTubeReaderBot Bot you agree with YouTube Terms of Service.
Use the @YouTubeReaderBot telegram bot to be the first to be notified when new videos are released on your favorite channels.
Look for new videos or channels and share them with your friends.
You can start using our bot from this video, subscribe now to TimescaleDB Course – PostgreSQL for Time-Series Data
What is YouTube?
YouTube is a free video sharing website that makes it easy to watch online videos. You can even create and upload your own videos to share with others. Originally created in 2005, YouTube is now one of the most popular sites on the Web, with visitors watching around 6 billion hours of video every month.
