Objectives

  • Understand how Oracle 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.
  • Master the execution plans and the corresponding work steps (table scanning, index access, sorting …)
  • Monitor performance with standard PostgreSQL tools and extensions.
  • Learn query tuning via the features available to the developer and/or DBA
  • Understanding 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 group

  • 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

Principal Consultant & Technology Leader Open Infrastructure

Thumbnail [150x150]

Hervé Schweitzer

Chief Technology Officer (CTO) and Principal Consultant