Objectives

  • Understand how PostgreSQL uses system resources (CPU, I/O, memory) and what to look for when configuring.
  • Learn how the Cost-Based-Optimizer (CBO) calculates the data path.
  • Learn all about execution plan operations (sequential scans, index access, sorts, etc.)
  • Monitor performance with standard PostgreSQL tools and extensions.
  • Learn about query tuning using the features available to the developer and/or DBA
  • Understand PostgreSQL index types
  • Using stored procedures
  • Understand memory sizing: shared_buffers, work_mem, …
  • Learn sequential scans and indexing

Method

  • Presentations, practical exercises, case studies and question-oriented demonstrations
  • Discussion and networking during breaks and lunch (included)

Target groups

  • This PostgreSQL Performance Tuning course is designed for PostgreSQL database administrators who want to improve the performance of their systems and for database developers who want to improve the performance of their applications.

Prerequisites

  • Be able to navigate on Linux shell
  • Have knowledge of databases
  • Have knowledge of PostgreSQL
  • It is recommended to take the PostgreSQL DBA Essentials training before

5% discount for SOUG, SwissPUG and DOAG members.

Trainers

Thumbnail [150x150]

Daniel Westermann

Delivery Manager & Technology Leader

Thumbnail [150x150]

Hervé Schweitzer

Chief Technology Officer (CTO) and Principal Consultant