PostgreSQL – Performance Optimization (PGSQL3)

Databases, PostgreSQL

This hands-on course focuses on practical PostgreSQL performance tuning, emphasizing configuration, query execution plans and indexes to improve throughput and reduce latency in real-world deployments.

Through labs and real examples you will learn tools for performance measurement, bottleneck identification and index-friendly query writing, plus strategies for reducing I/O, tuning WAL and scaling with replication and partitioning.

Location, current course term



VirtualPro (online)
11/17/2025 - 11/18/2025 CZECH
Order 		2/9/2026 - 2/10/2026 CZECH
Order
Custom Customized Training (date, location, content, duration)

The course:

Hide detail
  • Basic factors affecting database performance
    1. Application layer considerations
    2. CPU, RAM, I/O, network and environmental constraints
  • PostgreSQL architecture that impacts performance
    1. Server processes
    2. Memory management and configuration
    3. I/O operations
    4. WAL (Write-Ahead Logging)
  • Query processing
    1. Architecture overview
    2. Query processing stages
  • Optimal PostgreSQL configuration for performance
  • Identifying bottlenecks
  • Execution plans
    1. Overview
    2. Viewing, visualizing and interpreting plans
    3. Cost estimation
    4. Caching effects
  • Indexes
    1. How indexes work
    2. Index types
    3. B+ Tree vs Hash indexes
    4. GIN / GiST indexes
    5. Using indexes and writing index-friendly applications
  • Using indexes
    1. Operations accelerated by indexes
    2. Index-only scans
    3. HOT (Heap-Only Tuples)
  • Full-text search
    1. PostgreSQL full-text options overview
  • Indexing special data types
    1. JSON
    2. XML
    3. and other types
  • JOIN optimization
    1. Hash join
    2. Merge join
    3. Nested loop
  • Partitioning
    1. Overview
    2. Purpose and use cases
    3. Advantages and disadvantages
  • Caching in PostgreSQL
  • Scaling performance
    1. Overview
    2. Using replication for scaling
Assumed knowledge:
Basic computer skills; familiarity with database concepts is a plus.
Recommended previous course:
PostgreSQL – Programming in PL/pgSQL and Advanced Development Techniques (PGSQL2)
Recommended subsequent course:
PostgreSQL – Replication and High Availability (PSTGR3)
Schedule:
2 days (9:00 AM - 5:00 PM )
Course price:
576.00 € ( 696.96 € incl. 21% VAT)
Language: