DATABASE PERFORMANCE
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 MATERIALS

© 2019 Maciej Zakrzewicz