[DBA 3]
PostgreSQL
Expert
🗓️ Dates: will be announced later in the year
đź’» 5 live online sessions, 3h30m each
🎤 Includes: Q&A, theory and live demo
🏷️ Price: €850 before taxes
To participate in this course, you must have either completed ourÂ
[DBA1] PostgreSQL Essentials and [DBA2] PostgreSQL Advanced courses, or already have the equivalent knowledge.
For details see the course T&Cs.
This advanced deep-dive course is designed for experienced database administrators who want to master PostgreSQL internals and high-level operations.
- PostgreSQL architecture and Write-Ahead Logging (WAL)
- MVCC, VACUUM, and isolation levels
- Point-in-Time Recovery (PITR) and WAL archiving
- Declarative table partitioning
- Connection pooling with PgBouncer
What You’ll Learn
The course is designed to equip you with the essential skills to install, operate, maintain, and monitor PostgreSQL for reliable and efficient database management.
PostgreSQL architecture and Write-Ahead Logging
This chapter explains how PostgreSQL manages data through its memory architecture, background processes, and durability mechanisms. Highlights include:
- An overview of background processes and their roles
- The main memory areas and how they work
- How memory and disk interact
- The role of Write-Ahead Logging (WAL) in preventing data loss.
MVCC, VACUUM and isolation levels
This chapter explores how PostgreSQL maintains data integrity and high concurrency using Multi-Version Concurrency Control (MVCC), transaction isolation, and automatic background maintenance. Key topics include:
- How PostgreSQL stores multiple versions of a row and uses system columns like xmin/xmax and ctid
- How isolation levels (READ COMMITTED to SERIALIZABLE) affect consistency guarantees
- The internals of VACUUM and autovacuum: how dead tuples are cleaned, what triggers clean-up, and how to monitor or tune it
- Best practices for minimizing bloat and avoiding transaction ID wraparound
Point-in-Time Recovery and WAL Archiving in PostgreSQL
This chapter introduces the principles and practices of Point-in-Time Recovery (PITR) in PostgreSQL. Highlights include:
- Continuous archiving and its role in recovery
- Configuring WAL archiving for PITR
- Performing file system backups with pg_basebackup or manual methods
- Executing a point-in-time recovery and controlling recovery targets
- Best practices for backups, restore testing, and minimising downtime
Declarative table partitioning in PostgreSQL
This chapter introduces declarative table partitioning in PostgreSQL, a feature designed to simplify the management of large datasets. Highlights include:
- An overview of the partitioning methods: list, range, and hash
- How to define multi-column and nested (sub-)partitions
- Managing partitions: attach, detach, and default partitions
- Performance considerations and planning-time behaviour
- Common limitations and best practices for effective partitioning
Connection pooling in PostgreSQL with PgBouncer
This chapter explores how PostgreSQL can efficiently handle large numbers of client connections through connection pooling, focusing on PgBouncer. It covers:
- Why and when to use a connection pooler
- Comparison of pooling modes: session, transaction, and statement
- Installation, configuration, and monitoring of PgBouncer
- Advanced usage: delegated authentication, query cancellation, and multi-instance scaling
Format and Schedule
This extensive PostgreSQL course consists of 5 live sessions (3h30m each), delivered over five days, exact dates will be announced later in the year.
To receive a certificate of attendance, participants must attend all five sessions.
- Sessions will be conducted in English via Zoom.
- Participants must have the latest version of Zoom installed on their computer.
- Please note:Â Sessions will not be recorded.
- The course format combines theoretical slides with live demos, led by the instructor in real time. Each session includes a live Q&A for direct interaction.
- There are no scheduled breaks during the 3.5-hour sessions.
Â
Cost: €850 before taxes.
Session Schedule
(all times CEST)
Monday,
12 January
10:00–13:30
Â
Tuesday,
13 January
10:00–13:30
Â
Wednesday,
14 January
10:00–13:30
Thursday,
15 January
10:00–13:30
Â
Friday,
16 January
10:00–13:30
This extensive PostgreSQL course consists of 5 live sessions (3h30m each), delivered over five days, exact dates will be announced later in the year.
To receive a certificate of attendance, participants must attend all five sessions.
- Sessions will be conducted in English via Zoom.
- Participants must have the latest version of Zoom installed on their computer.
- Please note:Â Sessions will not be recorded.
- The course format combines theoretical slides with live demos, led by the instructor in real time. Each session includes a live Q&A for direct interaction.
- There will be a 10-minute break halfway through each 3.5-hour session.
Â
Cost: €850 before taxes.
We will announce Session Schedule later in the year.
Please register your interest in attending the course by filling out the form below.
By providing your information, you consent to its processing as described in our Privacy Policy and agree to receive updates and communications from Data Egret GmbH. You may withdraw your consent at any time.
Register now!
Course duration: 5 days, 5 sessions; 3.5 hours eachÂ
Course cost: €850 before taxes
Â
📝 Following the form submission: You’ll receive payment instructions via email.
đź’ł Payment Methods:Â Credit card or direct bank transfer.
⚠️ Important: Your spot is only confirmed once payment is received.
đź“© If you have any questions or issues, please contact us at [email protected]
Instructors
PostgreSQL Consultant
Stefan has close to 15 years of expertise in the database space, boasting extensive experience in client support, maintenance, and architectural consulting.
He is a recognised PostgreSQL contributor and a contributor to pgBackRest, a reliable backup and restore solution for PostgreSQL.
Senior PostgreSQL Expert