PostgreSQL: Administration, Reliability, Performance
Training Description
About the Training
The "PostgreSQL: Administration, Reliability, Performance" training is a comprehensive course aimed at system administrators, IT specialists, and programmers who wish to deepen their knowledge of managing, configuring, securing, and optimizing the PostgreSQL server. During the sessions, participants will learn both theoretical aspects of the database engine's operation and practical techniques for its configuration and maintenance. The training integrates topics related to administration, reliability, and performance into a single coherent program, enabling a full understanding of the PostgreSQL environment.
Training Objectives
- Understanding PostgreSQL architecture and operational mechanisms
- Learning server configuration and maintenance principles
- Acquiring skills in creating backups and replication
- Performance optimization and system resource management
- Enhancing security and reliability of the PostgreSQL environment
Book the Training
- Format: Remote
- Language: Polish
- Type: Open training, guaranteed
- Date: 24-25.11.2025, 3-5.12.2025
- Duration: 5 days (7h/day)
- Trainer: Maciej Zakrzewicz
Net price per participant. Guaranteed training requires a minimum of one participant.
Training Objectives
- Understanding PostgreSQL architecture and operational mechanisms
- Learning server configuration and maintenance principles
- Acquiring skills in creating backups and replication
- Performance optimization and system resource management
- Enhancing security and reliability of the PostgreSQL environment
Duration and Format
- Duration: 3 days (24 teaching hours)
- Format: Workshop training with practical exercises (on-site or online)
Training Program
Introduction to the PostgreSQL Database Server:
- architecture (processes, files)
- administrative tools
- installation, upgrade, starting, stopping
- configuration (configuration files and parameters)
- tablespaces, databases, schemas
- basic maintenance operations (vacuum, analyze, reindex)
Managing User Accounts and Permissions:
- authentication methods
- restricting network access to the server
- creating and modifying user account definitions
- creating groups/roles
- system and object permissions
Protecting Databases from Failure - Backups and Replication:
- database backups (logical: pg_dump, pg_dumpall, pg_restore; physical: pg_basebackup; incremental physical: pg_combinebackup)
- database recovery after failure
- WAL file archiving
- full and point-in-time recovery
- standard physical replication
- standard logical replication
- helper tools (barman, repmgr)
Managing PostgreSQL Database Server Performance:
- query execution plans, introduction to the Query Planner, statistics for the Query Planner
- using indexes, types of indexes (B-tree, hash, BRIN)
- advanced table structures (partitioned, unlogged, temporary, materialized views)
- utilizing buffer memory (Buffer Cache, Work Memory, Maintenance Work Memory)
- parallel queries (Parallel Query): architecture, monitoring, configuration
- monitoring load and performance (logging long-running queries, analyzing table and index load)
- PgBench tool - other performance optimization techniques
No funds for training? Get funding!
A program that allows you to easily and quickly secure funding for training for individual persons.
Why choose guaranteed training?
- Execution guarantee. The training will take place regardless of the number of participants.
- Exchange of knowledge and experience with specialists from other industries.
- Interactive, live sessions. Not just theory, but also practical exercises and discussions.
- Flexible remote format. Join from anywhere.
Need Help?
Reach out to learn more about our team and the kinds of tailored solutions we can offer your organization.
Get in Touchwroclaw@nobleprog.pl or +48 (22) 103 3718