The Database Performance course discusses main database server performance management problems. Topics include database server performance tuning, data caching solutions, dedicated physical and logical data structures (indexes, partitioned tables, materialized views), performance evaluation tools and standards (TPC).

Scope:

• Introduction to PostgreSQL: architecture, tools, startup and shutdown, configuration, Vacuum, Analyze, Reindex
• Authentication methods, users, roles, privileges
• SQL query optimization
• Advanced indexes
• Advanced data structures
• Parallel query
• Memory buffers
• Performance monitoring
• Replication and sharding
• Benchmarking Standards: TPC Benchmarking, history of benchmarks, TPC-C benchmark, TPC-H and TPC-R benchmarks.

Lecture: Introduction to PostgreSQL
Lecture: Query Optimization
Lecture: Optimizer Statistics
Lecture: Index Structures
Lecture: Advanced Table Structures
Lecture: Memory Buffers
Lecture: Parallel Query
Lecture: Replication and Sharding
Lecture: Workload Monitoring
Lecture: History of Database Benchmarks
Lecture: PgBench
Lecture: Other performance solutions
Lab #1: Practices (Query Planner)
Lab #2: Practices (Statistics)
Lab #3: Practices (Indexes)
Lab #4: Practices (Advance Table Structures)
Lab #5: Practices (Memory Buffers)
Lab #6: Practices (Parallel Query)
Lab #7: Practices (Replication)
Lab #8: Practices (Monitoring)
Lab #9: Practices (Benchmarking)
Lab #10: Practices (Workshop), Perf_workshop_build.sql file, Perf_workshop_pgbench.sql file
FINAL ASSIGNMENTS


Back