How does PostgreSQL utilize system resources effectively?
PostgreSQL leverages CPU, I/O, and memory resources efficiently. Understanding how these resources are utilized is crucial for configuring your PostgreSQL instance. This section will cover the details of resource management and optimization.

What are the best tools for monitoring PostgreSQL performance?
We will explore standard PostgreSQL tools and extensions designed for performance monitoring.

How do you optimize query performance in PostgreSQL?
This section delves into the techniques for query tuning, including an in-depth explanation of execution plan operations such as sequential scans, index access, and sorts.

What are the different PostgreSQL index types and how should they be used?
Gain a comprehensive understanding of PostgreSQL index types and their specific applications.

How do you configure memory settings for optimal performance?
Learn about memory sizing, including shared_buffers and work_mem, and how to configure these settings to achieve optimal database performance.

Seize this opportunity to enhance your technical expertise and improve the performance of your PostgreSQL databases.

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

PostgreSQL Performance Tuning will be delivered using a combination of presentations, practical exercises, case studies, and question-oriented demonstrations. You will have the opportunity to practice the skills you learn in the course on a hands-on lab environment.

Target audience

  • 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

Benefits

The PostgreSQL Performance Tuning Performance course provides numerous technical advantages for users:

  • Efficient Resource Utilization: Learn to configure PostgreSQL efficiently to utilize CPU, I/O, and memory resources effectively, ensuring optimal performance.
  • Advanced Query Optimization: Understand how to tune queries using PostgreSQL’s features, including execution plan operations, to achieve faster and more reliable query performance.
  • Comprehensive Monitoring and Tools: Acquire skills in monitoring PostgreSQL performance using standard tools and extensions, enabling proactive performance management and troubleshooting.

Participants in this course will receive practical, expert instruction in PostgreSQL performance tuning, enhancing their ability to manage database systems effectively. They will become adept in utilizing PostgreSQL’s features for high availability, scalability, and optimized performance. Additionally, learners will have access to resources and insights from our expert consultants through PostgreSQL-focused blogs and discussions.

For detailed information, refer to the official PostgreSQL documentation.

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