Show training

PostgreSQL: Performance management

training code: pgSQL-ZW / ENG AA 2d / EN

level Basic

For more information, please contact the sales department. For more information, please contact the sales department.
3,500.00 PLN 4,305.00 PLN with TAX

The training is addressed both to administrators and developers responsible for diagnosing and troubleshooting SQL query performance in PostgreSQL 16 environment.

During the training the participants will acquire knowledge:

  • Query Planner functioning,
  • interpreting and modifying query execution plans,
  • the use of data indexing techniques,
  • the use of temporary and partitioned tables,
  • the use of materialized views,
  • parallel SQL query execution,
  • configuring buffer memory,
  • generating extended statistics,
  • detecting performance problems,
  • performance tests automation.

Knowledge of SQL language, knowledge of PostgreSQL database server architecture.

  • Training: English
  • Materials: English
  • 2 days of work with a trainer
  • Trainer’s supervision
  • Contact with community
  • Coursebook
  • Lab environment

Training method

  • lecture
  • workshops
  1. Introduction to Query Planner (functioning, configuring)
  2. Analyzing query execution plans
  3. Collecting and expanding statistics for Query Planner
  4. Index structures (B*-tree, hash, BRIN, GIN, GiST, partial, function-based)
  5. Advanced table structures (partitioned, unlogged, temporary, materialized views)
  6. Configuring buffer memory (buffer cache, work memory, maintenance work memory)
  7. Parallel queries (execution plans, configuration)
  8. Diagnosing performance problems (logs, pg_top, auto_explain, pg_stat_statements, cumulative statistics)
  9. Using pgBench to implement simple system performance tests
  10. Other techniques of performance tuning (prepare/execute, hints, sorting records physically, calculated columns, fillfactor)