• Understand PostgreSQL's internal architecture and how it affects performance
• Master transaction management and isolation levels
• Learn how to analyze and optimize query performance
• Gain practical experience with TimescaleDB for time-series data
• Develop skills to identify and resolve common performance bottlenecks

• Introduction 
  
• Understanding PostgreSQL Architecture 
• Exercise 1: Storage Deep Dive
• Exercise 2: System Catalog Explorer

Hour 2: Transactions and Query Optimization

• Transaction Management
  
• Exercise 3: Transaction Isolation Laboratory
• Query Planning and Execution
• Exercise 4: Query Optimization Challenge

• VACUUM and Maintenance
• Exercise 5: VACUUM Investigation
• TimescaleDB Integration
• Exercise 6: Building a Time-Series Analytics System

Required Setup

• PostgreSQL 15+ installed locally
• Ruby 3.0+
• TimescaleDB extension
• Sample dataset (provided)
• Workshop repository with exercises

Hands-on Exercises Format

• Each exercise: 10-15 minutes

• Pair programming encouraged

• Solution review and discussion

• Common pitfalls and best practices

Follow-up Materials

• Exercise solutions
• Performance tuning scripts
• Recommended monitoring queries
• Further reading resources