TR

PostgreSQL Performance Optimization Course

Course Audience

PG202
1 DAY

System administrators who manage a PostgreSQL database service and aim to enhance its performance.

Course Prerequsities

Informations that required by participants before course:

  • Participants who will join this course should also have joined PG101, PG201 courses before or mastered related subjects of these courses.

Course Goals

  • Selecting the right hardware to improve PostgreSQL performance
  • Configuring necessary settings in the Linux operating system to enhance PostgreSQL performance
  • Adjusting PostgreSQL parameters to improve performance
  • Measuring the performance of SQL queries and identifying slow queries
  • Measuring the impact of indexes on performance and optimizing indexes

Course Subjects

  • Introduction to Performance Improvement
  • Hardware Performance
  • Operating System Settings
  • Optimization in SQL Queries
  • Logging Slow Queries
  • Query Planning
  • Table Statistics
  • Indexing
  • Vacuuming and Auto Vacuum
  • Adjusting Database Parameters