Channel BannerChannel Banner
gYTA8nQN030gYTA8nQN030

TimescaleDB Course – PostgreSQL for Time-Series Data

103,136
Socialcounts.OrgEnter Fullscreen (f)
629
likes
29
comments
daily view 0
monthly view 0

Share

Live Analytics

Comments 0

TimescaleDB Course – PostgreSQL for Time-Series Data Analytics Table

Income Estimates for TimescaleDB Course – PostgreSQL for Time-Series Data

Based on this YouTube video's total view count of 103K views and industry-standard rates, the estimated total earning is $72 - $206 through ad revenue. Historical data is not yet available to calculate daily, weekly, or monthly averages.

About TimescaleDB Course – PostgreSQL for Time-Series Data

Explore TimescaleDB Course – PostgreSQL for Time-Series Data with 103,136 views, 629 likes, and 29 comments. Experience the impact of this video content that has captured audience attention.

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. Created by @beau 🏗️ 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

About YouTube Real-Time View Count

With SocialCounts.org’s view counter, track your YouTube video’s live view count and YouTube likes count in real time with fast, reliable updates.

Watch every YouTube video live view count rise with our real-time YouTube views tracker—built for accuracy and minimal delay.

Follow YouTube real time views as they happen, using our dedicated view counter for YouTube videos.

Get up-to-date live view count on YouTube and see real-time growth with SocialCounts.org’s smart tracking tools.

Embed Widget

Parameters:

  • fullscreen=true - Fullscreen counter
  • graph=true - Live graph chart
  • counter=0/1/2 - Select counter (0=likes, 1=views, 2=comments)
URL

Click to copy the embed URL to your clipboard